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