BPC 7.5 NW Processing Dimensions Microsoft.Office.Interop.Excell issue

[Former Member]

Hi

I've tried all the downloads (service Packs, Interop Files etc) mentioned in all websites and posts to try and fix following error:

"Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel_Application'. This Opperation failed because the Query Interface call on the COM component for the interface with ID '{000208D5-0000-0000-C000-0000000000046}' failed due to the following error: Library not registered.

I get this only when I try to Process a dimension

Please can anyone tell me how to fix this?

We have installed BPC 7.5 NW

I had Office 2010 and could process but my input schedules didn't work 100% on Office 2007 so I had to go back to 2007. And now I can't process in the Admin Client. I've uninstalled and reinstalled Office and BPC 7.5 NW SP07 a few times to try and solve this but no luck.

Thanks

Johan Fourie

[Former Member]

Hi Johan,

Can you check this note as well if it helps.

1547132 - Microsoft.Office.Interop.Excel, or one of its dependencies, was not found

Regards,

Sachin

[Former Member]

Hi,

If you are using excel 2007, you need to install the redistributable primary interop assembly from the below link:

https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F...

Hope this helps.