Request for improved method

Our take

Managing a vast accounts payable tracker with 110,000 rows and extensive columns presents significant challenges, particularly with Excel freezing and crashing. While you've made noteworthy improvements, the current setup may be hindering your productivity. Exploring innovative methods to handle this considerable dataset is essential. Whether through advanced Excel tools or alternative data management solutions, there are opportunities to streamline your processes. Your experience, while not exhaustive, positions you well to leverage new approaches for a more efficient and effective tracking system.

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]

Read on the original site

Open the publisher's page for the full experience

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