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. |
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. |
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 01:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com