SHRINK/REDUCE EXCEL FILE SIZE

[Ashish Jain]

Hi Friends,


A useful post on reducing the excel workbook size. This may reduce
the
file size dependently from 10% to 500% .
http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html

________________________________________
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
________________________________________

 

[Walter Briscoe]

In message <[email protected]
s.com> of Thu, 25 Nov 2010 05:15:31 in microsoft.public.excel.programmin

Hi Friends,


A useful post on reducing the excel workbook size. This may reduce
the
file size dependently from 10% to 500% .
http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html

[snip]

Change = new size - old size
Proportional Change = Change / old size
Percentage Change = Proportional Change * 100

Consequently, Percentage Change has a -100 limit.
[old size = 1, new size = 0, Percentage change = ((0-1)/1)*100]

It is possible for the old size to be 500% of the new size.
[old size = 5, new size = 1, Percentage change = ((1 - 5)/5)*100 = 80]

cf. <http://en.wikipedia.org/wiki/Percentage_change>

What formulae are you using? Why?