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

●
●
●
●
●
FactoryTalk Historian DataLink User Guide
68
You must move or clear an entire Excel array including all cells, or DataLink
displays an error message: You cannot change part of an array.
You can also copy the values from a function array if you want to use them
elsewhere in a spreadsheet. Once you copy and paste the values, they are
no longer part of a function array; they are simply cell values and are not
updated. To copy array values:
 Select the function values you want, copy them, and use Paste Special
to paste them in the desired location.
You do not need to select the entire array column or row to copy
values.
Update Arguments
You can update a function array with new argument values:
1. Right-click and select the function name from the context menu (2003
or 2007), or display the function dialog box or task pane.
The corresponding function dialog box appears and displays the
current arguments in the appropriate edit fields.
2. Change any parameters as desired to update the array with new
arguments, and click OK or Apply.
If the Output Cell argument is changed, the results depend on the
location of the new cell reference:
 If the new cell reference is part of the original array, then the
entire array is moved such that the upper-leftmost cell of the array
is placed in the newly-referenced cell.
 If the new cell reference is not part of the original array, then the
array is copied and pasted with the upper-leftmost cell located in
the newly-referenced cell. The original array remains in its
original location.