2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel to digital asset manager?

Hi. I have something like 10,000 entries of designs that my company uses all in 8 spreadsheets with multiple tabs of each. This is how they started organizing and tracking designs long before I started working here. However, these spreadsheets are highly unstable as we have multiple users adding to them daily and the legacy spreadsheets have jpgs and not pngs. They often crash, or worse, one user will log a design, inserted as a PNG, along with a few columns of descriptions, and when another user opens the spreadsheet, that entry or multiple entries don't carry over.
We have explored ways to avoid this – turning off autosave did help. But it does keep happening.
It seems that because we have thousands of images, sometimes copied into a cell and not inserted, we need to find a new method to catalogue our work. I tried to set up airtable but it requires manual import of each image. So, I'm wondering if you smart people could recommend a solution, away from Excel, to make something like this work. A paid service, app or platform is fine
Thanks

https://preview.redd.it/y6658b8hfolg1.png?width=1190&format=png&auto=webp&s=a2bb3bb6f41984701040b7dcb5df9064dbc4dfc6

submitted by /u/air621
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#financial modeling with spreadsheets
#natural language processing for spreadsheets
#big data management in spreadsheets
#AI-native spreadsheets
#predictive analytics in spreadsheets
#Excel compatibility
#Excel alternatives for data analysis
#digital transformation in spreadsheet software
#rows.com
#modern spreadsheet innovations
#self-service analytics tools
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#digital asset manager
#Excel