SHRINK/REDUCE EXCEL FILE SIZE
 

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/sh...file-size.html

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

SHRINK/REDUCE EXCEL FILE SIZE
 

In message
s.com of Thu, 25 Nov 2010 05:15:31 in microsoft.public.excel.programmin
g, Ashish Jain writes
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/sh...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?
--
Walter Briscoe