Related Posts
$DPZ 370c 3/27
What’s does “fill the gap” mean??
$BABA got murdered today. Buy, hold, or sell?
Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.








I think the question is more why is it huge; like is it rows upon rows of formula, links to external workbooks, are there embedded images etc. I have reduced loads of formula calculations through VBA…. In meantime, turn off automatic calculations, and only calculate manually when you need to.
Save as an XLSB to start. The file size will shrink a ton and be faster in general to save and open
You can keep both versions active, no need to only stick to one save file if unwanted
Bro trying to run a whole company out of a spreadsheet 🤣
For real though
Turn off autocalculation for formulas
Thanks for tips
Get rid of unneeded names ranges and external references. That can get bloated depending on where you're getting your data from.
If it’s old data you can always hard code formulas, if you know it’s not changing. For me it’s excel plugins that kill it where I need that shortcut most. If it’s too big then maybe try moving to power BI
Yea I’m trying to move to power bi now
Use tableau or alteryx
think through what you are retaining and if you have any empty cells that think they have data
When files get huge, it’s usually because Excel is being used as both the database and the reporting layer.
At some point, separating the data layer from the output layer makes a massive difference.
Are you storing raw historical data in the same workbook as the dashboards?