(Sorry, my last post wasn't formatted properly... Here it is again.)

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
----------------------------------------------