size of excel files

[Guest]

Hi is there anyway to find out exactly what in an excel
file is contributing to its size? I wish to optimize for
size. The spreadheet has a significant number of charts,
worksheets, some VBA (which originally had a huge number
of code until I reedited). The file is currently 1Mb.

Thanks in advance

 

[Frank Kabel]

Hi
only some things to test:
- used range of your sheets
- number of formulas
- inserted pictures
- charts, etc.

But AFAIK there's no method to determine which of these parts are
causing which amount of memory usage

 

[Dave Peterson]

Throw away the stuff that you want to consider (one at a time).
Save it as a new name and compare the filesize?

Reopen the real version and do it again (and again and again).

I pretty much let excel be excel. If there's something I need to keep, then I
keep it.

The only exception I have to this is that I like to reset the last used cell of
each worksheet.

I'll use one of the techniques that is documented on Debra Dalgleish's site:
http://www.contextures.com/xlfaqApp.html#Unused

(1 meg doesn't seem like a lot to me.)

 

[David McRitchie]

Hi Thanks.....,
Nothing specific but a recent request to split a workbook up into
separate files for each worksheet does provide the means to see
which sheets are taking up the most space by browsing the directory
created that holds the individual sheets.
Saveas, Save each worksheet as a separate workbook
http://www.mvps.org/dmcritchie/excel/saveas.htm

 

[Guest]

Thanks guys... I was hoping there is an easy way.. But
your advice has narrowed the problem down for me..

Thanks