This project has moved. For the latest updates, please go here.

Started getting an error using PTE

Dec 2, 2014 at 7:34 PM
My computer is running Windows 7 and Microsoft Office 2007. I have been using your PTE for several years with this set up with no issues. Last week I had Visio 2010 installed on my computer and I am now getting the below error when trying to filter a pivot table using the PTE. I'm assuming the install of Visio is what has caused the problem... Its the only thing that I can think of that changed. I uninstalled and reinstalled the lates version 0.8.4.0(32-bit) and I'm still getting the error.

I've become extremely dependant on this extension. Any help getting it working again would be greatly appreciated


Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).

at Microsoft.Office.Interop.Excel._Application.get_LanguageSettings()

at OlapPivotTableExtensions.MainForm.SetCulture(Application app)

at OlapPivotTableExtensions.MainForm.workerFilterList_DoWork(Object sender, DoWorkEventArgs e)

OK

Coordinator
Dec 2, 2014 at 9:21 PM
I have seen this reported once or twice but haven't tried to repro or workaround this yet.

I did have an idea. Can you try installing the Excel 2010 PIAs?

https://olappivottableextend.codeplex.com/wikipage?title=Office%202010%20Primary%20Interop%20Assemblies
Dec 3, 2014 at 1:08 PM
Just to confirm, you want me to install Excel 2010 PIAs even though I'm running Excel 2007?
Coordinator
Dec 3, 2014 at 1:48 PM
Yes. Not sure that will work but worth a try
Dec 3, 2014 at 4:51 PM

I installed the Excel 2010 PIA's and it did not fix the problem. I even tried to uninstall the OPE and reinstall after installing the Excel 2010 PIA


Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).

at Microsoft.Office.Interop.Excel._Application.get_LanguageSettings()

at OlapPivotTableExtensions.MainForm.SetCulture(Application app)

at OlapPivotTableExtensions.MainForm.workerFilterList_ShowCurrentFilters_DoWork(Object sender, DoWorkEventArgs e)

OK