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