No, my file is not open. I understand (now) that that is what is causing the
error. Is there a way around this?

"pdberger" wrote:

Two things to check:

* Is your other file -- the source file from which you're extracting info
-- open? It has to be open or this file can't extract info.
* Have you inadvertently moved your other, source file?

"Julie Quass" wrote:

I am linking information between workbooks and using the following formula to
get my desired result:

=MID(CELL("filename",'filepath[file.xls]sheet.reference),FIND("[",CELL("filename",'filepath[file.xls]sheet.reference)+1,4)

I got the results I was looking for, saved the file and then closed it.
When I reopened the file, regarless of whether or not I updated the links, my
results all turned to #N/A. What am I doing wrong or what needs to be
changed?

Thanks for your help!