Huge file size

[lakota]

I have a excel file that has all of a sudden grown to a
huge size 19,278,336 . It is stock market data with a
worksheet for each year of data (1968 to 2004). So 35
worksheets.

For years it has always run about 1.8 meg. Just this year
it has all of a sudden grown with no real difference in
the data I add each day.

Each row has 9 columns of data advances, declines, etc.
There are 21 columns that make calculations based on the
preceding 9 columns. But years 1968 - 2003 just have
data, not formulas. I converted the cells to numbers from
formulas.

And I had several charts, but I deleted those, saved and
reopened. I now have only one chart that is a separate
workesheet. Still a huge file.

The other thing is when I put in a day's worth of data and
recalculate now, it takes about 5 minutes to do so. It
used to just takes a few seconds. (I have a fast machine -
pentium 2000 512 memory, etc.)

I am only recalculating one workesheet as I said and I
only add another row of calculations each day. I cut and
paste the formulas from the previous day.

Any help would be appreciated. Thanx

 

[Frank Kabel]

Hi
maybe the following site helps you:
http://www.contextures.com/xlfaqApp.html#Unused

 

[Norman Harker]

Hi lakota!

It's possibly a false used range thing so see:

Debra Dalgleish:
http://contextures.com/xlfaqApp.html#Unused

Also worth visiting is:

Charles Williams:
http://www.decisionmodels.com/optspeedd.htm#Size

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Michael J. Strickland]

I had the same problem and the following worked:

For each sheet:
1. Select the sheet tab.
2. Click on " Move or Copy".
3. Check the "Create a Copy" Checkbox
4.Delete the original sheet (Select sheet tab, click delete).
5. Rename the "Copy of" sheet to your original name.

Try this on a few sheets and then save the file and see if it reduces the
file
size any. If so, continue with he remaining sheets.