Please help me!

[khanhtt]

I have an excel file as monthly report. Everymonth I input new value
overwrite onto fields of file (replace old value). But I dont know why
file size is increased after each change time.

Thanks a lot!

 

[Anne Troy]

Try the following to see if it helps:

1.
http://www.officearticles.com/excel/clean_up_your_worksheet_in_microsoft_excel.htm

2. Copy the worksheets to a new workbook.

3. File-->Save as to a new name.

One or all of these should help, so I would save and check the properties
each time in between.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Dave Peterson]

How much does the file size vary between changes?

I've seen this happen to. I just attributed it to the way excel works.
Sometimes I could make a change the file size would go up, sometimes the
filesize would go down.

But it wasn't a major change in size.

 

[David McRitchie]

Down, Huh?
Well if you work at it you fix the last cell indications that get messed up
when you insert and delete rows or columns.

Why do my scrollbars go to row 500 -- my data ends in cell E50?, Debra Dalgleish
http://www.contextures.com/xlfaqApp.html#Unused

 

[Dave Peterson]

Yep. But it was a very small difference in file size--IIRC, 15k on a workbook
that was between 1 meg and 1.5 meg.