recalc question

  • Thread starter Thread starter Bura Tino
  • Start date Start date
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
 
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
 
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
recalculation of a custom function in excel 4
Recalc Time 5
User Function Not Recalculating 5
cell does not recalc 3
Volatility, recalculation 7

Back
Top