Find volatile cells

[hmm]

Is there a way to find or select cells containing a volatile formula? The
formula could be used explicitly in the cell, or may be substituted by a name
whose definition contains a volatile function.

 

[Peo Sjoblom]

You can download volatilefuncs from here

http://www.decisionmodels.com/calcsecretsi.htm



--


Regards,


Peo Sjoblom

 

[hmm]

Thanks Peo.

VolatileFuncs seems to be a worksheet of miscellaneous functions
demonstrating which ones are always recalculated. How can I use it to help
me find all volatile cells on my worksheet?

 

[Charles Williams]

I don't think there is a sensible way of doing this except by searching for
the name of each volatile function.
In excel 2007 you might be able to get somewhere by analysing the
calculation chain information which is accessible in the new file format.

Even if you parsed out all the function calls in all the formulae in the
workbook so you knew where they all were there is no general way of telling
whether a particular function is volatile except by testing it.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com