recalc question

B

Bura Tino

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
 
J

John Wilson

Bura,

Excel doesn't keep track of where it was "opened from"
It does keep track of where it was "saved last".
If you move the file and then open it, it thinks that it's still
in the old location. If you save the file in the directory from
which it was opened, your function should work correctly.

John
 
B

Bura Tino

OK, so what do I do in the scenario when the file is moved and then
opened from a different directory? Or, better still, emailed to
someone?

How about a kluge: thisbookname(rand())?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force Recalc 3
Recalc versus enter 20
Excel Recalc All except one sheet 0
User Function Not Recalculating 5
Recalc Time 5
cell does not recalc 3
Volatility, recalculation 7
Calling VBA function from a worksheet 7

Top