Application.Volatile
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
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
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
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. |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com