•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sheet is too big, laptop keeps crashing
Our take
Dealing with a massive spreadsheet can be frustrating, especially when your laptop struggles to keep up. A 300,000-line sheet can overwhelm even the most robust systems, leading to crashes and slow performance. Instead of relying solely on formulas, consider breaking down your data into smaller, more manageable sections. Explore options like filtering, pivot tables, or using cloud-based tools designed for large datasets. These strategies can enhance your productivity and help you navigate your work without the constant interruptions of crashing.
I am working on my work laptop. I'm dealing with a 300,000 line sheet. The formulas were making it crash so I copy and 123pasted to try and make it work. But it's still too big, I can't scroll down without it crashing. Any advice?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Online spreadsheet stuck on loading screenI've been making a budget tracker for myself using Excel online. I've spent quite a bit of time setting it up, I've tried to add a couple charts to visualise the data but as soon as ive selected an entire column as a data source (it only has 10 values in it so far) it crashes the entire spreadsheet and it gets stuck infinitely loading. This is now the third time I've had to recreate it from scratch due to issues around charts. Is there any way I can get it to load or do I just need to give up using excel. submitted by /u/GhostDog_1314 [link] [comments]
- Request for improved methodI 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]