3 Replies Latest reply on Nov 10, 2017 9:04 PM by AndrewTitus

    2015 PI Datalink Tab Missing From Excel 2010 Pro (32bit).

    AndrewTitus

      I am having a bit of a strange issue with the PI Data Link on one of my customers computers. The PI data link tab does not show up in excel regardless of trying the solutions posted in the following KB. https://techsupport.osisoft.com/troubleshooting/KB/KB00265

       

      When I disable the VSTO_SUPPRESSDISPLAYALERTS by setting the value to 0 in the environment variables, this is the error I get.

       

      I tried the following:

      • Installing .Net Programmability Support
      • Installing Office 2010 Developer Tools
      • Changing LoadBehavior DWORD value to 3
      • Installing PI Process Book Language Pack
      • Restarting Computer

       

      ************** Exception Text **************

      1. System.MissingMethodException: Method not found: 'Microsoft.Office.Core.LanguageSettings Microsoft.Office.Interop.Excel._Application.get_LanguageSettings()'.

         at OSIsoft.PIDataLink.UI.ThisAddIn.ThisAddIn_Startup(Object sender, EventArgs e)

         at Microsoft.Office.Tools.AddIn.OnStartup()

         at OSIsoft.PIDataLink.UI.ThisAddIn.FinishInitialization()

         at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.ExecutePhase(String methodName)

         at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.ExecuteCustomizationStartupCode()

         at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.ExecuteEntryPointsHelper()

       

       

      ************** Loaded Assemblies **************

      mscorlib

          Assembly Version: 2.0.0.0

          Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)

          CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

      ----------------------------------------

      1. Microsoft.VisualStudio.Tools.Applications.Runtime

          Assembly Version: 8.0.0.0

          Win32 Version: 8.0.50727.940

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.dll

      ----------------------------------------

      System

          Assembly Version: 2.0.0.0

          Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

      ----------------------------------------

      1. System.Xml

          Assembly Version: 2.0.0.0

          Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

      ----------------------------------------

      1. Microsoft.Office.Tools.Common

          Assembly Version: 8.0.0.0

          Win32 Version: 8.0.50727.940

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Tools.Common/8.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.dll

      ----------------------------------------

      1. System.Windows.Forms

          Assembly Version: 2.0.0.0

          Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

      ----------------------------------------

      1. System.Drawing

          Assembly Version: 2.0.0.0

          Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

      ----------------------------------------

      1. OSIsoft.PIDataLink.UI

          Assembly Version: 4.0.3.0

          Win32 Version: 4.2.1.0

          CodeBase: file:///C:/Program%20Files%20(x86)/PIPC/Excel/OSIsoft.PIDataLink.UI.DLL

      ----------------------------------------

      1. OSIsoft.PIDataLink.Functions

          Assembly Version: 4.0.3.0

          Win32 Version: 4.2.1.0

          CodeBase: file:///C:/Program%20Files%20(x86)/PIPC/Excel/OSIsoft.PIDataLink.Functions.DLL

      ----------------------------------------

      office

          Assembly Version: 15.0.0.0

          Win32 Version: 15.0.4613.1000

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/office/15.0.0.0__71e9bce111e9429c/office.dll

      ----------------------------------------

      1. Microsoft.Office.Interop.Excel

          Assembly Version: 14.0.0.0

          Win32 Version: 14.0.4756.1000

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/14.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll

      ----------------------------------------

      1. Microsoft.Office.Tools.Common2007

          Assembly Version: 8.0.0.0

          Win32 Version: 8.0.50727.940

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Tools.Common2007/8.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common2007.dll

      ----------------------------------------

      1. Microsoft.Office.Tools.Excel

          Assembly Version: 8.0.0.0

          Win32 Version: 8.0.50727.940

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel/8.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.dll

      ----------------------------------------

      office

          Assembly Version: 14.0.0.0

          Win32 Version: 14.0.4760.1000

          CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/office/14.0.0.0__71e9bce111e9429c/office.dll

      ----------------------------------------