File size increases with each save

G

Garbunkel

Hello,

I am working with an Excel file (using Excel 2000, version
9.0.3821 SR-1) that contains four worksheets. One of the
worksheets contains a simple macro timestamp macro &
conditional formatting in one of the columns (to change the
text to a certain color depending on the value contained in
an adjacent cell). The rest of the workbooks contain regular
text data (20000 rows & 8 columns in all), with no macros
or conditional formatting. The regular data was pasted
from several tables in Microsoft Word.

What I have noticed is that the filesize (which started at
approximately 8 MB) increases by a few KB every time I do a
save, even if no data was added, removed or modified. Over
time, this inflated to about 45 MB! I copied all of the data to
a new 4-worksheet Excel file, keyed in the macro &
conditional formatting and saved it. The result was an 8 MB
Excel file that was identical in every other way.

Does anyone know what could be causing the file size to
balloon like this?

Thanks in advance for any helpful input.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top