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

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("filenam e"))-SEARCH("[",CELL("filename"))-1))

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

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.

yossie6 wrote:

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("filenam e"))-SEARCH("[",CELL("filename"))-1))

--

Dave Peterson