Factors affecting Excel File Size

[M P]

As mentioned on the subject. Is it charts? Linked values? Macros?

 

[Frank Kabel]

Hi
often this is:
- used range (see: http://www.contextures.com/xlfaqApp.html#Unused)
- number of formulas
- objects (e.g. charts, images, etc.)

Also see:
http://www.decisionmodels.com/memlimits.htm

 

[M P]

I already made some test are here is the result:
I have 3.56MB of excel file with chart

I have remove Linked value to different files and reduce the file size to
2.4MB

Removed objects and unused formula and the file reduce to 2.26 from 2.4MB

I conclude that these factors have huge contribution on making excel file
size grow