| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking error
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #Value error when linking workbooks | Excel Worksheet Functions | |||
| how do i solve 'file not found' error when linking notebooks? | Excel Worksheet Functions | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Threaded Mode
