Is there a formula that will pull in the ACTUAL filename of the ACTUAL workbook, instead of the ACTIVE workbook?
I currently use the following code to list the filename of each workbook in cell A1.
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)
However, when I have several similar workbooks open, I notice that this formula is not listing the ACTUAL filename, but the filename of the ACTIVE workbook. So if I hit "save" in WorkbookA, then the value of cell A1 in all other open files resets to WorkbookA. I would like cell A1 in each cell to retain its actual filename.
I have tried resetting the workbook calculation setting from 'automatic' to 'manual', but that doesn't prevent this from happening.
Bookmarks