Hi,

I have a function thisbookname() which returns the full path name of
the file. However, if the file is moved to another directory and then
opened, the content of the =thisbookname() cell is not updated. F9
does not change the value. Nor does the VBA "Recalculate" command.

How to fix this?

Thanks!

Bura