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))

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