Automatic Update feature

The Automatic Update feature automatically initiates a recalculation of functions and trends at a specified interval. Automatic Update applies to any workbook opened by the same Excel session. Automatic Update pauses when you open a menu, task pane, or window, or you have the current worksheet in edit mode. Automatic Update cannot update protected workbooks, which are read-only.

Your preference settings affect Automatic Update:

• Type of update

  A preference setting determines which functions update during Automatic Update. There are two choices:

  • Calculate (F9)

    Select this option to recalculate all volatile functions and any functions that reference them during each recalculation.

  • Full Calculate (Ctrl+Alt+Shift+F9)

    Select this option to recalculate all functions, regardless of volatility, during each recalculation.

• Frequency of update

  In the Interval field, enter the number of seconds between automatic recalculation. The minimum value is five seconds. Enter 0 to have PI DataLink automatically set the interval to twice the calculation duration, with a minimum interval of five seconds. AVEVA recommends you use the automatic interval to ensure that Excel remains responsive 50% of the time.

  If the recalculation takes longer than the specified interval, a message prompts you to switch to the automatic interval or to turn off Automatic Update.

See also

Manage PI DataLink settings from Excel

Activate Automatic Update

Cancel Automatic Update