View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bill Martin
 
Posts: n/a
Default Utility to "clean up" or "defrag" large Excel file

Sabrina wrote:
Is there a tool/utility that I can run on a very large Excel file to
essentially "clean up" the file? This file has existed for a while - lots of
things added and deleted....I is there such a utility?

Thanks!


------------------

The only sort of clean-up that I'm aware makes a meaningful difference is if
your file has accumulated a bunch of empty data rows for which Excel still
stores formatting information. It can sometimes double the size of your stored
file. Hit Ctrl-End on a sheet and if the cursor goes to a cell well beyond the
end of your actual data then you have an opportunity to get rid of some meta data.

Look at Debra's website for a solution (and a lot of other good stuff!)

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

If you have a bunch of disused macros then I suppose you can delete them too
though that's never made much improvement in my particular cases.

Good luck...

Bill