Why is my 11-pg .xls file 35 MB (yes, EM bee)?

T

Teelbee

Why is my .xls file 35 MB (yes, EM bee)?

I have an excel file with 11 worksheets. Each sheet is
less than 1 page of figures. Some cells derive their
values by looking up a cell in another worksheet. The
print area is defined for each sheet.

Saved separately, the individual worksheets are only 15 to
50 KB a piece, which is what I would expect.

All together, I would expect the file size to be under
500k, not 35 MB.

Dang! I don't get it! (I'm not a frequent excel user -
I've probably done something really bone head, but I
cannot image what.

Teelbee
 
D

David McRitchie

Hi Teelbee,
Don't have any specific answer, but you might want to check
that the last used cell position is correct. Ctrl+End
more information on my lastcell.htm#makelastcell webpage.

You might try separating the sheets with a macro just to
check the sizes in the c:\temp\ directory, strictly as a means
of identification not suggesting you reduce workbooks to one
sheet each.
Saveas, Save each worksheet as a separate workbook
http://www.mvps.org/dmcritchie/excel/saveas.htm

You might find something additional in
Slow Response, Memory Problems, and Speeding up Excel
http://www.mvps.org/dmcritchie/excel/slowresp.htm

Since there are not definite solutions any feedback you
can supply would help others.
 
Top