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

Request for improved method

I work in accounts payable for a company and took over some additional duties a few months ago. One of those duties is keeping a tracker/log of all bills that come in. A tracker in excel was handed over to me. While I’ve improved many things with this tracker so far, I’m looking to make a major change but unsure how to go about it. This tracker has 110k rows of data and has columns with data up to column “FZ”. New rows of data are added daily. Old rows are “archived” as soon as possible. I’m no excel pro, but can hold my own and have learned along the way.

Issue: large dataset presents challenges with excel freezing and/or crashing

Disclaimer: I cannot remove any rows or columns.

Question: is there a better way to handle this data? Ie. tools in excel, using something other than excel, etc?

submitted by /u/Visible-Question-786
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#generative AI for data analysis
#rows.com
#data visualization tools
#data analysis tools
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#enterprise data management
#big data performance
#data cleaning solutions
#financial modeling with spreadsheets
#large dataset processing
#natural language processing for spreadsheets
#self-service analytics tools
#business intelligence tools
#collaborative spreadsheet tools