"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION

  • Thread starter Thread starter yossie6
  • Start date Start date
Y

yossie6

there are more side effects like when there are few files open that
have the same form the name of the closed file transfered to the
remain one.
i used this formula
(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH(".",CELL("filename"))-SEARCH("[",CELL("filename"))-1))
 
Use
=cell("Filename",a1)

Without the range reference, excel will use the whatever worksheet/workbook that
is active to evaluate that function.

You can really use any cell you want. I usually use the address of the cell
that holds the formula.
there are more side effects like when there are few files open that
have the same form the name of the closed file transfered to the
remain one.
i used this formula
(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH(".",CELL("filename"))-SEARCH("[",CELL("filename"))-1))
Click to expand...
 
Back
Top