Spreadsheet File Size

[aresar]

I have a Spreadsheet that has 10 tabs at the bottom. Each of thes
sheets cross reference dataand thee are many complex calculation
throughout. Many of the formulas are nested IF functions which I kno
take up a lot of space. The unfortunate thing is the file size is 7
MB, which is hard for others in the office to work with.

I would appreciate any ideas as to how I could reduce the file size.
For example:

- Is there a way or someone who could look at this and kind of audi
it to see if there are ways to reduce size?

- Should I break it up into seperate files (shich would be harder fo
other users with less experience.

Any suggestions would be appreciated. Thank You

 

[mzehr]

Hi,
Have a look at:
http://www.decisionmodels.com/memlimits.htm

HTH

 

[Gord Dibben]

Also check out http://www.contextures.on.ca/xlfaqApp.html#Unused

You may have unused cells that Excel thinks are in service.

Gord Dibben Excel MVP