Reducing the size.

[MFS]

I am using a file contains about 10 sheets, each sheet contain 5,000 cell,
each cell contain a function or a formula.

Whenever I open the file it takes long time, also when I close it.

Is there any way I can use to reduce this time, like removing column and
rows that I do not need, or anything else??

 

[Jim Thomlinson]

As a guess you file ahs been bloated with unused cells. Follow the directions
here to clean the file up...

http://www.contextures.com/gluten.html

 

[Jim Thomlinson]

Sorry wrong link... However if you are Gluten intollerant it is handy...
Try this one...

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

 

[Dave Peterson]

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

(Unless glutens do cause bloating <vbg>.)

 

[Dave Peterson]

Oops. I should have scrolled down a bit. I didn't see your correction post.

 

[Debra Dalgleish]

Thanks Jim! You never know how that gluten information might help,
although I haven't tested it with Excel files. <g>