View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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