Hello,

Is it possible to execute the volatile method like an on/off button. To
refresh the data only when I want to.
Also, can retrieve if the status of the volatile methode ?

Thank you in advance.

If you set Calculation to Manual, the F9 key will do what you're requesting
--
Kevin Backmann


"Nader" wrote:

Hello,

Is it possible to execute the volatile method like an on/off button. To
refresh the data only when I want to.
Also, can retrieve if the status of the volatile methode ?

Thank you in advance.

it doesn't work at all.

"Kevin B" a écrit dans le message de
news: ...
If you set Calculation to Manual, the F9 key will do what you're
requesting
--
Kevin Backmann


"Nader" wrote:

Hello,

Is it possible to execute the volatile method like an on/off button. To
refresh the data only when I want to.
Also, can retrieve if the status of the volatile methode ?

Thank you in advance.

Application.Volatile is not like other application level settings as it is
not a persitent setting. Primarily what it does is it tags the cell that it
is in as always being dirty (in need of a recalc). If you are using xl2002 or
better then you can manipulate the dirty setting yourself through code and
potentially eliminate the need for the volatile setting. Check out this link
for a bit more info...

http://www.decisionmodels.com/calcsecrets.htm
--
HTH...

Jim Thomlinson


"Nader" wrote:

Hello,

Is it possible to execute the volatile method like an on/off button. To
refresh the data only when I want to.
Also, can retrieve if the status of the volatile methode ?

Thank you in advance.