Worksheet sharing

To share PI System data with others, you can share worksheets created with PI DataLink. To determine the best way to share your worksheets, consider the following:

• You can send a PI DataLink workbook to another Microsoft Excel user. The user must have PI DataLink installed and an active connection to the same Data Archive server and PI AF server in order to recalculate functions and see dynamically updated PI point and PI AF attribute values.

• Those who do not have PI DataLink installed can still see the last data saved in the worksheet, provided the Excel Workbook Calculation option is set to Manual before they open the worksheet in Excel. See Set Workbook Calculation option to manual.

• You can also save a worksheet as a web page or PDF file to share a static version of the worksheet.

• You can copy values from function arrays to new locations on a worksheet using the Paste Special command. Although the worksheet data can no longer be recalculated once copied, this method allows you to distribute a customized snapshot of data to anyone who has a copy of Excel. See Common function array tasks.