Curious Excel file size management

Duane

Board Regular
Joined
Mar 14, 2002
Messages
228
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.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Duane

Board Regular
Joined
Mar 14, 2002
Messages
228
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,057
Messages
5,599,545
Members
414,316
Latest member
ExcelLee

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
Top