I use this formula to but the file name in a cell. =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1).
This works perfectly. I then use another formula in a different cell to parse out a value from filename =MID(J1,FIND("e_0",J1)+3,2). This also works perfectly. Until I open a second excel workbook. the CELL formula up[dates in workbook A with the file name of workbook B and then the dominoes fall. I hit F9 and the name corrects but I am curious about the behavior.
Is this expected behavior? why? seems wrong. Ideas?
This works perfectly. I then use another formula in a different cell to parse out a value from filename =MID(J1,FIND("e_0",J1)+3,2). This also works perfectly. Until I open a second excel workbook. the CELL formula up[dates in workbook A with the file name of workbook B and then the dominoes fall. I hit F9 and the name corrects but I am curious about the behavior.
Is this expected behavior? why? seems wrong. Ideas?