Right-click menu

PI DataLink adds several commands to the standard Microsoft Excel right-click menu. You can use these commands to manage function arrays in a worksheet.

To open the right-click menu with the PI DataLink commands, right-click anywhere in a PI DataLink function array.

PI DataLink adds the following commands to the right-click menu:

• Select DataLink Function

  Selects the entire function array.

  You should select an array before you copy, cut, or paste it to a new worksheet location.

• Recalculate (Resize) Function

  Rewrites the entire function array: PI DataLink retrieves new values from Data Archive or PI AF and automatically resizes the array to fit the returned data.

• Function Name

  Opens the corresponding function task pane and shows inputs for the function array.

• Convert to Dynamic Array

  Converts the function to a dynamic array

See also

Function task panes