Related Posts
I got a remote L6 SWE offer at Google but the RSUs are too low for that level ($625k over 4 years), could not negotiate it higher. I’ve accepted the offer but trying to be hopeful that I could make it more equitable in the future if I perform well. Are stock refreshers based on the initial RSU grant or solely based on performance? Google
Additional Posts in Excel Genius
Still don't have xlookup. #fomo
Anyone know what these badges are?

New to Fishbowl?
unlock all discussions on Fishbowl.






It's probably formulae making it crash. If it is just due to a lot of data I would use power query + power pivot.
Optimize for the number of tables you create and their associated formulas. You can always select the check performance button under the “Review” and see how many cells can be optimized.
If it's gotten to the point where it crashes:
First I'd disable the auto load of formulas. If the file js no longer slow then your issue is likely formulas that read a lot of cells and use a lot of inferences. Worst case you might have to debug by removing formulas until you find the formula that breaks your computer.
Then I go through the sheets and delete and rows or columns not used. Don't know if this is still a thing but on older versions having blank cells would affect the load speed as Excel would be trying to read empty cells. More of a old habit these days.
Next I check for cell/conditional formatting and remove them all for similar reasons. Also checking links and connections to see if the file is actively reading from another file (you can supersede this step using powerquery to load the table into the file using Excel.Workbook(File.Contents(filepath,null,true) IIRC).
I've had files with dozens of columns and thousands of rows run fairly easily. The issue may be a data modelling one and you'll have to think about how the data is brought into the file and how you use it. Powerquery can be a good alternative.
All fails it might just be your laptop is a bit crap and it's time to ask IT for an upgrade.
Save the file as .xlsb
It turns the file in a binary file that is more manageable, faster and takes up less space. It works just fine but might struggle a bit with if you use formulas connecting external data or so I was told. Never had issues so far.
Might be time to switch to coding