Curious Excel file size management

Duane

Board Regular
Joined
Mar 14, 2002
Messages
229
I had a workbook with a sheet for information input into a table, and then a bunch of output sheets with formulas set up as forms for output (select a key, display relevant info, and print or PDF). The file was reaching 2MB and, surprisingly, started taking noticeably longer to recalc (I'm using the xlsm format on a machine with 8GB RAM, and a 2MB spreadsheet is getting noticeably slower? And Microsoft wonders why folks like to hate on their obsession with bloat).

So, I pulled out several of these output sheets into their own separate workbook. Now the main workbook size is still 1.6MB and each new workbook I created is over 700KB. I might have thought I'd save a little more than 400KB after removing six sheets each of which created 700KB workbooks on their own.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Wow, that's a lot to read, but thanks!

Let's see if I can get my head around it all sufficiently to make a difference in how I set up a workbook.
 
Upvote 0

Forum statistics

Threads
1,211,985
Messages
6,105,220
Members
447,957
Latest member
Basildon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top