View Single Post
  #3   Report Post  
Old October 25th 06, 02:10 PM posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
Posts: 2,574
Default 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

Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave F" wrote in message ...
|I was reading this white paper on performance optimization in XL 2007,
| , 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.