Function task panes

Use function task panes to define PI DataLink functions.

A task pane is a panel of controls that you can move and dock. You can continue to work on a worksheet while a task pane is open.

To open a function task pane:

• Select the desired output cell, and then select a function command on the PI DataLink tab to add a function.

• Select a cell in an existing function array to open the corresponding task pane and edit the function inputs.

  Note: You can turn off automatic display of task panes if you prefer. See Manage PI DataLink settings from Excel.

• Right-click a function-array cell, and then select the function name to manually open the task pane.

In an open function task pane:

• Enter or change input values, and then:

  • Select OK to save the input values, write the resulting function array, and close the task pane.

  • Select Apply to save the input values and write the resulting function array without closing the task pane.

• Select the arrow button to select the Move, Size, or Close commands.

• Drag the title bar to undock the task pane.

• Double-click the title bar to dock the task pane.

• Place your cursor at the edge and drag to resize the pane.