Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find volatile cells
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find volatile cells
You can download volatilefuncs from here
http://www.decisionmodels.com/calcsecretsi.htm -- Regards, Peo Sjoblom "hmm" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find volatile cells
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? "Peo Sjoblom" wrote: You can download volatilefuncs from here http://www.decisionmodels.com/calcsecretsi.htm -- Regards, Peo Sjoblom "hmm" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find volatile cells
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 "hmm" wrote in message ... 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? "Peo Sjoblom" wrote: You can download volatilefuncs from here http://www.decisionmodels.com/calcsecretsi.htm -- Regards, Peo Sjoblom "hmm" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX - volatile or not? | Excel Worksheet Functions | |||
is MATCH a volatile function? | Excel Discussion (Misc queries) | |||
VBE Geeks in Volatile Functions | Excel Worksheet Functions | |||
why is the INDIRECT function volatile? | Excel Worksheet Functions | |||
is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) |