software

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

Thanks!

Sabrina

Generally file size is increased due to Excel thinking the used range on sheets
is much larger than what it really is.

This is caused by adding rows and columns then clearing them. Excel still
retains these cells as quot;usedquot;.

See Debra Dalgleish's site for methods of resetting the used range on sheets.

www.contextures.on.ca/xlfaqApp.html#Unused

Also if you have a lot of VBA code in modules you can clean them up using Rob
Bovey's codecleaner add-in

www.appspro.com/Utilities/CodeCleaner.htmGord Dibben MS Excel MVP

On Thu, 12 Jan 2006 06:19:02 -0800, quot;Sabrinaquot;
gt; wrote:

gt;Is there a tool/utility that I can run on a very large Excel file to
gt;essentially quot;clean upquot; the file? This file has existed for a while - lots of
gt;things added and deleted....I is there such a utility?
gt;
gt;Thanks!Sabrina wrote:
gt; Is there a tool/utility that I can run on a very large Excel file to
gt; essentially quot;clean upquot; the file? This file has existed for a while - lots of
gt; things added and deleted....I is there such a utility?
gt;
gt; 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!)

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

Bill Martin wrote:
gt; Sabrina wrote:
gt;
gt;gt;Is there a tool/utility that I can run on a very large Excel file to
gt;gt;essentially quot;clean upquot; the file? This file has existed for a while - lots of
gt;gt;things added and deleted....I is there such a utility?
gt;gt;
gt;gt;Thanks!
gt;
gt;
gt; ------------------
gt;
gt; The only sort of clean-up that I'm aware makes a meaningful difference is if
gt; your file has accumulated a bunch of empty data rows for which Excel still
gt; stores formatting information. It can sometimes double the size of your stored
gt; file. Hit Ctrl-End on a sheet and if the cursor goes to a cell well beyond the
gt; end of your actual data then you have an opportunity to get rid of some meta data.
gt;
gt; Look at Debra's website for a solution (and a lot of other good stuff!)
gt;
gt; www.contextures.com/xlfaqApp.html#Unused
gt;
gt; If you have a bunch of disused macros then I suppose you can delete them too
gt; though that's never made much improvement in my particular cases.
gt;
gt; Good luck...
gt;
gt; Bill

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

Note that you may want to also check the current thread quot;Huge Files Don't Know
Whyquot; on this board. Somebody there had a few hundred unused named ranges that
also took up space. Dave Peterson pointed to an automated solution there.

Bill