Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why is the INDIRECT function volatile?
I was reading this white paper on performance optimization in XL 2007,
http://msdn2.microsoft.com/en-us/library/aa730921.aspx , and it indicated that the function INDIRECT is volatile. I can't figure out why that function would be volatile. Thoughts? -- Brevity is the soul of wit. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why is the INDIRECT function volatile?
That probably is because Excel bases dependencies on cell references. And a text (like "B1") is not seen as a cell reference.
So if A1 contains "B1" and C1 is =Indirect(A1) and if you change the value B1, C1 would not be recalculated if Indirect wasn't volatile. -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave F" wrote in message ... |I was reading this white paper on performance optimization in XL 2007, | http://msdn2.microsoft.com/en-us/library/aa730921.aspx , and it indicated | that the function INDIRECT is volatile. I can't figure out why that function | would be volatile. | | Thoughts? | | -- | Brevity is the soul of wit. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why is the INDIRECT function volatile?
That makes sense, thanks.
-- Brevity is the soul of wit. "Niek Otten" wrote: That probably is because Excel bases dependencies on cell references. And a text (like "B1") is not seen as a cell reference. So if A1 contains "B1" and C1 is =Indirect(A1) and if you change the value B1, C1 would not be recalculated if Indirect wasn't volatile. -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave F" wrote in message ... |I was reading this white paper on performance optimization in XL 2007, | http://msdn2.microsoft.com/en-us/library/aa730921.aspx , and it indicated | that the function INDIRECT is volatile. I can't figure out why that function | would be volatile. | | Thoughts? | | -- | Brevity is the soul of wit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidate data using 3d function AND indirect | Excel Worksheet Functions | |||
INDIRECT function inside AND function | Excel Worksheet Functions | |||
include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
Using Indirect Function | Excel Worksheet Functions | |||
INDIRECT function error | Excel Discussion (Misc queries) |