Excel 2000 File Size Explosion

[Rich]

I have a 5 MB Excel 2000 workbook with 2 worksheets, the first is
10x10 of data, the second is about 16000x50 of data with about a dozen
charts of this data. I can open the file up and it's properties say 5
MB.

When I save the file or save under another name, the file size jumps
to 47 MB. This is after doing absolutely nothing to it, except
opening it up and saving it.

The "Last Cell" is in the correct location on both sheets before and
after saving. There is no VB code in this workbook. I tried column
formatting everything to remove individual cell formats. Regardless
of all this, it is at 5MB on my disk, and just saving it again causes
it increase by a factor of almost 10!!!!

Anyone have any ideas?

 

[Lady Layla]

Are you saving as workbook or saving as 97-2000,95 version?


: I have a 5 MB Excel 2000 workbook with 2 worksheets, the first is
: 10x10 of data, the second is about 16000x50 of data with about a dozen
: charts of this data. I can open the file up and it's properties say 5
: MB.
:
: When I save the file or save under another name, the file size jumps
: to 47 MB. This is after doing absolutely nothing to it, except
: opening it up and saving it.
:
: The "Last Cell" is in the correct location on both sheets before and
: after saving. There is no VB code in this workbook. I tried column
: formatting everything to remove individual cell formats. Regardless
: of all this, it is at 5MB on my disk, and just saving it again causes
: it increase by a factor of almost 10!!!!
:
: Anyone have any ideas?

 

[Rich]

I am saving as workbook. I found one way to chop it down, I was using
the big worksheet as a sort of template, so i could just cut and paste
data in and have it chart automatically. All the charts referenced
the maximum number of cells in each column, even though some columns
may have only a few hundered rows of data or be empty depending on the
dataset. I resized the chart column references to reflect the actual
data available, and the size did not blow up when saving. Weird.