Posted to microsoft.public.excel.misc
|
|
Reducing the size.
Oops. I should have scrolled down a bit. I didn't see your correction post.
Jim Thomlinson wrote:
Sorry wrong link... However if you are Gluten intollerant it is handy...
Try this one...
http://www.contextures.com/xlfaqApp.html#Unused
--
HTH...
Jim Thomlinson
"Jim Thomlinson" wrote:
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
--
HTH...
Jim Thomlinson
"MFS" wrote:
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??
--
MFS22
--
Dave Peterson
|