App file size

[Sam Ricca]

I have a spreadsheet application that has many report pages with lookup
formulas that read data for several storage sheets. The storage sheets are
populated by VBA that lays a row of data and deletes the 1st row of data to
maintain a usable file size. This process is done daily.

The file should'nt grow in size, but it does (slightly--5 - 6K daily) and
has for nearly 2 years. How can this happen if the same amount of data is
being deleted as added?

Thanks,

Sam

 

[Gord Dibben]

Sam

It can grow as Excel doesn't reset the used range very nicely.

See Instructions for resetting used range on sheets at Debra Dalgleish's site.

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

Gord Dibben Excel MVP