Thanks for the quick reply, Mark. You are correct in that the #REF seems to be an issue with BIFF formatted files but I've created files sans the Analysis Toolpack addon and it still occurs. Here's an example of what I'm seeing: I've created
two blank Excel workbooks, Book1, Book2. Cell "A1" in Book2 references cell "A1" in Book1. Very simple external reference example. I save both workbooks in the following formats: BIFF(xls), 2007XML(xlsx), 2003XML(xml). The results of calling
getValue("A1") on Book2 results in the following results respectively:
It appears that the only format that truly returns the actual formula with the external reference string is the 2003XML format. Sans the ability to open a BIFF file and save it as a 2003XML file there doesn't seem to be any way for me to grab the underlying
formula out of a BIFF file. Is there any work around you can think of? Thanks.