Issue After installing PI DataLink, the PI DataLink tab in the Office Ribbon does not appear. PI DataLink Ribbon in Excel 2016 Case 1 Symptoms • The PI DataLink Excel add-in ( OSIsoft. Pipc32.xll) may be listed in the Active Application Add-Ins list, but the COM add-in ( OSIsoft.PIDatalink.UI.vsto vstolocal) is not (see ). • In the dialog to manage COM add-ins, the check box for the PI DataLink add-in is unchecked. • The PI DataLink tab is not added after checking the box and clicking OK. • When you reopen the COM add-ins dialog, the box is still unchecked.

• The PI DataLink tab only appears in the ribbon when running Excel as an administrator. Case 2 Symptoms • The PI DataLink tab does not appear on the Office Ribbon immediately after installing PI DataLink. This case does not apply to Office 2007.

• Neither the PI DataLink Excel add-in ( OSIsoft.pipc32.xll) nor the COM add-in ( OSIsoft.PIDatalink.UI.vsto vstolocal) COM add-in are listed in the Active Application Add-Ins list (see ). Case 3 Symptoms • The PI DataLink Excel add-in ( OSIsoft.pipc32.xll) may be listed in the Active Application Add-Ins list, but the COM add-in (OSIsoft.PIDatalink.UI.vsto vstolocal) is not (see ). • In the dialog to manage COM add-ins, PI DataLink add-in is not present.

Case 4 Symptoms • PI DataLink 2010 (version 4.x) is installed • Microsoft Visual Studio 2012+ or Office 2013+ is installed • You may see the following error when trying to enable the PI DataLink COM add-in: Not loaded. A runtime error occurred during the loading of the COM Add-in. Case 5 Symptoms If you are having trouble with loading the PI DataLink ribbon and none of the above cases apply, please follow to use the Windows environment variable VSTO_SUPPRESSDISPLAYALERTS to show additional error messages which may narrow down the root cause of your issue.

With PI DataLink. PI DataLink User Guide 1. References to Microsoft Excel 2007 apply to Microsoft Excel 2007 and later. To get the multi-language support. And run the PI DataLink installation kit. Or added to web part pages. Or familiarity with either Microsoft Excel or PI DataLink functions. Gb instruments circuit alert gvd 504a manual. See the OSIsoft Tech Support site: http. PI Datalink and PI Process Book. I believe it is part of the SDK (Software Development Kit) that PI offers along with their product.

Case 6 Symptoms Recently there have been numerous cases with Microsoft 365/ClicktoRun and Datalink 2014 and onwards. The error message that you see is similar to case 4 'Not loaded. A runtime error occurred during the loading of the COM Add-in.' You may also see 'Not a valid Office-Add In' when you try to load the COM add-in.

Solution The Solutions for the different cases are noted in the text below. These same solutions are also in the OSIsoft YouTube Video: Case 1 Solution To verify and correct the problem in Excel 2007 and later: • Click on the Office 2007 button (or File tab in Office 2010 and 2013) in the upper left corner. • Choose 'Excel Options.' • Select Add-ins> Manage 'Disabled Items' > Go.

If PI DataLink ( OSIsoft. PIDataLink.UI.dll.manifest) is disabled, enable it and then continue with the following: • Choose to Add-ins> Manage 'COM Add-Ins'> Go. • Select the Check box beside PI DataLink and click 'OK.'

In this case, check the registry key at HKEY_CURRENT_USER Software Microsoft Office Excel AddIns PI DataLink. The LoadBehavior DWORD should be set to 3. For more information, refer to Microsoft MSDN library.

If the PI DataLink tab still does not appear in the Ribbon, please follow to use the Windows environment variable VSTO_SUPPRESSDISPLAYALERTS to show additional error messages. Case 2 Solution VSTO Add-ins such as PI DataLink use the registry key to specify the run time behavior of the Add-in. If PI DataLink is not loading, the LoadBehavior may not be set to 3 (Loaded/ Load at Startup) for PI DataLink, in which case the Add-in will not be loaded as expected. Please see for details. It contains specific locations for the registry keys based on the versions of PI DataLink, the Operating System, and Microsoft Office, as well as examples of correct values. Alternatively, under certain conditions, the Office 2010 Primary Interop Assembly (PIA) required by PI DataLink does not get installed during the original Office 2010 installation.

The reason is that the PIA only gets installed with Office 2010 if the.NET Framework exists on the operating system prior to Office 2010 installation. The conditions/caveats for this issue are as follows: • The PIA issue does apply if PI DataLink is installed on Office 2010. • The PIA issue does not apply if PI DataLink installation has ever worked previously on the computer or if PI DataLink 2013+ is used. • The PIA issue should not occur with Windows 7 since it comes installed with.NET Framework 3.5 SP1 by default. • Similar symptoms will occur if you are using 64-bit Office 2010 which is not supported by PI DataLink 2010.