I have no knowledge of any third-party tool such as you describe.

However, I did download the Sobolsoft Excel file reducer setup.exe and ran it.

If you just keep clicking No to the "do you want to register etc." you can get
the file reducer to work.

It dropped the sizes on a couple of workbooks I had set up with artificially
large used ranges.

Sobolsoft deleted all the unused rows and columns on sheets, which Debra's code
does.


Gord Dibben MS Excel MVP


On Mon, 26 Jun 2006 09:10:02 -0700, Rima wrote:

Thanks Gord,
I am able to do it, yet I was wondering if there is an actual tool that does
that. When I searched on Google, I found that Sobolsoft has a tool. Yet due
to the fact that all of the trial versions need you to actually sign up and
pay to use it, I am reluctant to buy it without trying it.
I want a tool that our users are able to use so they can fix this process
themselves.

Rima

"Gord Dibben" wrote:

Rima

Debra Dalgleish has VBA code to reset the used range on each worksheet in a
workbook.

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


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 07:23:02 -0700, Rima wrote:

When making excel workbooks, I found that excel puts in a lot of extra
programming, therefore making the size of a workbook go up to 25MB. Which
causes difficulty when e-mailing the workbook. A solution found is by
deleting all extra empty cells, yet this is impractical.
Is there a way to clean it up without having to manually erase all of the
extra cells.

Thanks