How to determine what is causing large size

[Dave H]

I received a 41mb excel file. It has 25 tabs but not that much data o
each tab. I tried seperating each tab and determined that most tab
are well under 1mb. How do I determine what is using so much memory?

Thanks for any help

 

[Jim Thomlinson]

Take a look on each tab and look for a tab where your scroll bars allow you
to scroll well past the end of the data. On those tabs Hit Ctrl + End. All of
the cells between A1 and the cell that was just selected are all stored in
memory. They might appear empty but they are still using memroy just like any
other cell. To fix the problem...

http://www.contextures.com/xlfaqApp.html#Unused