Victoria B
New Member
- Joined
- Mar 10, 2006
- Messages
- 11
I have several large templates, pulling data through an ODBC connection, so I have them set to manual calculation to speed up processing time.
There will be dozens of people who use these templates; most of whom will not remember that they need to recalculate periodically to receive refreshed data.
Macro security setting are set to high by default, so using an event (or even a custom function) won't work.
Does anyone know of a way that I could have a formula in a cell display the word "Recalculate", when it is necessary? If I did, I could add some nice, obnoxious formatting that would get people's attention.
Thanks for your help,
Victoria
There will be dozens of people who use these templates; most of whom will not remember that they need to recalculate periodically to receive refreshed data.
Macro security setting are set to high by default, so using an event (or even a custom function) won't work.
Does anyone know of a way that I could have a formula in a cell display the word "Recalculate", when it is necessary? If I did, I could add some nice, obnoxious formatting that would get people's attention.
Thanks for your help,
Victoria
