Microsoft Excel file size

[g3a3n3n3]

HI,

This should be a fairly simple question. What make an excel file size increase? Does the size increase based on number of sheets, formulas or VBA code?

I know that a combination of these will make up a file size but lets say I have two files... both starting with th same amount of data and both arriving at the same result

File 1 - comes the it's conculsion inviolving fewer calculations (formulas) but lots of VBA code

File 2 - comes the it's conculsion inviolving more calculations (formulas) but no VBA code

File 3 - is a combination of VBA code & formulas and worksheets

Which file would be larger in size?

Thanks
Gillian

 

[fredericofonseca]

very easy to find.

create 3 workbooks each one with the attributes you mentioned, and then compare the sizes.

Then add more data/code and measure again. And so on until you reach a conclusion.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com