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!