ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   why is the INDIRECT function volatile? (https://www.excelbanter.com/excel-worksheet-functions/116045-why-indirect-function-volatile.html)

Dave F October 25th 06 01:50 PM

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.

Niek Otten October 25th 06 02:03 PM

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.



Dave F October 25th 06 02:10 PM

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.





All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com