Troubleshooting PI DataLink Spreadsheets:


  1. Ensure PI DataLink is available in the Excel Menu. If not then call the help desk to troubleshoot this issue.
  2. Under the PI DataLink menu, click on Settings, then Connection Manager. Make sure his1c and his2d are available.
    If the servers are listed click the ”Close” button to exit the Servers box then the ”Cancel” button to exit the Settings box. For typical end users, the standard servers are:

 Server Name

Description

his1c

LVVWD PI data

his2d

SNWS PI data

afprod

Asset Framework data
  1. If they are not present, contact helpdesk to add the missing server(s).
  2. On the Excel spreadsheet, check the PI formula to see if the server name is part of the tagname.
     In the example above, the cell B2 uses a PI formula to get data. On different spreadsheets, the formula location will be different. This example gets data from two different PI servers, thus the server name needs to be part of the tagname. The tag in C1 does not have the server name on it and cannot get data from the server. The tag in cell D2 has the server name with the tagname and can get data.
  3. Add the server name to the tag. LVVWD tags from WonderWare start with “VVHIS01” and are under the PI server his1c. SNWS tags from Ovation start with 4 letters that are abbreviations for pump or rate of flow stations and are under the PI server his2d. In the case above in cell C1, it should look like \\his1c\VVHIS01.FAYL_2168_FI_7020.Val (note the extra backslashes).
  4. If you see the message “Resize to show all values”, right-mouse click on the message and choose “Recalculate (resize) Function”.