Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recalc question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
recalc question
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 Bura Tino wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
recalc question
...
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())? 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 Bura Tino wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't stop recalc | Excel Worksheet Functions | |||
cell does not recalc | Excel Worksheet Functions | |||
How to tell Excel to recalc, unconditionally, now? | New Users to Excel | |||
Run recalc until a specified vaule is reached. | Excel Discussion (Misc queries) | |||
Automatic Recalc | Excel Worksheet Functions |