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