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

●
●
●
●
●
FactoryTalk Historian DataLink User Guide
66
Manual recalculation is the best method for variable-size arrays (page 69)
where the number of values returned may differ. If more values are
available than the current size of the array, an array does not expand to
display the additional values on recalculation unless it is manually
recalculated.
To manually recalculate a single function:
 Right-click in any part of an array and choose Recalculate (Resize)
Function from the context menu.
 Update function arguments in either version of FactoryTalk Historian
DataLink. The array values refresh when you click OK or Apply to
close the dialog box or task pane, even if no changes are made to
function arguments.
Excel key combinations can also be used to recalculate all spreadsheets in
a workbook, essentially a manual, on-demand version of Automatic
Update. To recalculate all spreadsheet functions:
 Press F9 to force all volatile functions (and any functions that
reference them) to recalculate.
 Press Ctrl+Alt+Shift+F9 to force all functions to recalculate.
Functions and Array Values
When you add a function to a spreadsheet, FactoryTalk Historian DataLink
enters the active function syntax into the target cell. Once defined, a
function queries the FactoryTalk Historian server and returns values, which
appear in the same cell used to enter the function.
The difference between the actual content of cells and the surface display
of data values retrieved by a function should be familiar to users of
Microsoft Excel. For new users of Excel, it helps to keep this distinction in
mind, and remember that the actual content of a spreadsheet cell always
appears in the Excel formula bar, and not necessarily in individual
spreadsheet cells.