We have a simple opinion on the story posted by /u/tr0028: the spreadsheet is not the problem, but the tool is. A 300,000-line sheet should not crash a modern laptop. The fact that it does tells you everything you need to know about the limits of legacy spreadsheet software. When someone has to copy and paste values just to keep the application from freezing, the application has already failed them.
The real issue here is not file size. It is the architecture underneath. Traditional spreadsheets were designed for manual calculation and small datasets. They load everything into memory, recalculate every cell on every change, and treat 300,000 rows as an edge case rather than a routine workload. That design made sense twenty years ago. It does not make sense now. The user's instinct to strip formulas and paste values is a workaround, not a solution. It trades functionality for stability, and it still does not fix the scrolling problem. You should not have to choose between having formulas and having a usable file.
What this means in practical terms is that the category needs to evolve. AI-native spreadsheets handle large data differently. They process calculations in the cloud, not on your laptop. They optimize memory usage so that a 300,000-row sheet loads and scrolls like a 1,000-row sheet. They also let you keep your formulas live because the engine does not bog down when you add a VLOOKUP or a SUMIFS across hundreds of thousands of cells. The user in the Reddit thread deserves a tool that treats their data as normal, not as a burden.
So here is the concrete point: stop fighting your spreadsheet. If your laptop is crashing on a dataset of this size, the answer is not to strip your formulas or upgrade your hardware. The answer is to use a tool built for the data you actually work with. Explore a smarter way. Your workflow should not require a workaround.