sstackhoTEST@yahooTEST.com
Guest
Re: CELL("filename") acting Volatile? (in assoc. with PULL)
(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
----------------------------------------------
Bookmarks