Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 72)

●
●
●
●
●
FactoryTalk Historian DataLink User Guide
64
All workbooks open in the current Excel session are calculated
immediately, and then at specified intervals based on your Automatic
Update preference settings.
Automatic Update remains activated (with an indicator message in the
Excel status bar) until it is toggled off. During a recalculation event the
status bar also displays the calculation interval.
Automatic Update cannot update protected workbooks, which are read-only.
Review the following for additional information:
Calculation
Interval
Calculation interval is a preference setting (page 29) that is measured
in seconds, and must be greater than 5 seconds.
A value of 0 represents an automatic interval in which DataLink
adjusts the time between calculation cycles to twice the calculation
duration time, with a minimum interval of 5 seconds. The automatic
interval is recommended to insure that Excel remains responsive 50%
of the time.
You can adjust the Automatic Update interval manually to allow more
time between updates. If recalculation takes longer than your
specified interval, a message prompts to switch to the automatic
interval setting, or to turn off Automatic Update entirely.
Note that updates are paused when a menu, task pane or dialog box
is open or the current spreadsheet is in edit mode.
Cancellation Press Esc to cancel a recalculation in process. DataLink finishes
calculation for the currently-processing function, and Calculation
aborted appears in unprocessed function array cells. If you cancel
during an update while Automatic Update is on, DataLink turns
Automatic Update off.
Triggered Recalculation
In Excel, functions recalculate based on a triggering event. If you do not
use the Automatic Update functionality, you can maximize the refresh
frequency and keep function arrays current by referencing volatile time
functions within non-volatile FactoryTalk Historian DataLink functions.