excel 2002 - file growth out of control.

[steph]

Hi folks,

Have a bit of a problem. My company has a daily report using excel where
we copy/paste info from an external source into it. when we were using 97,
the growth of the file was fine(would go from a 1meg file to a 1.5meg file
most times), but now that we're using the 2002 version, the files sizes are
getting pretty silly(again from a 1meg file up to a 3-3.5 meg file.)

After some testing, it is because of the four worksheets we paste into. We
paste into it, run a macro to move that info into the places we want it,
then clear the page....yet those pages are retaining the information that
was pasted into it(although not visibly). If we remove those worksheets from
the file, the file size is significantly reduced.

So I guess my question would be, is there a way to either compress or purge
deleted info from excel files that the program/file might be keeping hidden
somewhere in the off chance we might need it again?

Thanx for any help you can provide,

Steph.

ps - can you please respond to (e-mail address removed) Thanx.

 

[Andy B]

steph

It might be as simple as resetting Excel's perception of the used range on
each sheet. Try this macro which is one I picked up from this NG.

Sub Reset_Range()
ActiveSheet.UsedRange
End Sub

Andy.