AnsweredAssumed Answered

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

Question asked by AndrewTitus on Nov 10, 2017
Latest reply on Nov 10, 2017 by 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

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

Outcomes