Hello,
I was using Harlan Grove's PULL function for the first time, and found that it had started
behaving in a Volatile manner, when it shouldn't have.
I was able to hunt down the problem to my formula that builds the reference that PULL uses. As
a step in building the directory of the external workbook, I used "=LEFT(CELL
("filename",A1),FIND("[",CELL("filename",A1))-1)" to return the directory of the current
workbook. This formula is the problem. When I remove it, PULL no longer acts Volatile.
But it was my understanding that CELL("filename") was not volatile. (Sources:
<http://www.decisionmodels.com/calcsecretsi.htm and
<http://support.microsoft.com/kb/211370/EN-US/)
Does anyone know why things became volatile in my workbook?
(BTW, I wrote a tiny UDF to return the directory of the current workbook, instead of using the
CELL function, and the workbook works fine now.)
Thanks,
Shawn
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------