Error trying to Open Embedded Excel2007 Docs with Add-in Active

Sep 1, 2011 at 4:56 PM

Hi ,

We’re having an issue with the OLAP PivotTable Extensions add-in. When it’s active, we cannot open embedded Excel tables that are connected to SSAS Cubes within Word docs. 

If I just go in and de-activate the add-in , however, the embedded Excel table will open (this requires re-booting which I’m not ready to do at this point, but it does work).

I’d like some help in figuring out a way to have the add-in activated and still allow embedded Excel tables to open. 

We are running word2007,excel2007 with SSAS 2008 and the latest version of the add-in . The Error message is "Microsoft Office Word can't start the application required to open this object.
An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?"

Thanks

Mike

Coordinator
Sep 1, 2011 at 5:11 PM

Wow. I didn't know you could do that! Can you walk me through step by step how you created that?

Sorry about the problems my tool is causing. I'll try to reproduce this and fix it in a future version of OLAP PivotTable Extensions.

Coordinator
Sep 2, 2011 at 1:32 AM
Edited Sep 2, 2011 at 1:41 AM

I'm able to reproduce this error in Excel 2010 and Word 2010 with OLAP PivotTable Extensions. The error message I get is "The program used to create this object is Excel. That program is not installed on your computer. To edit this object, you must install a program that can open the object." when you try to double click on an excel object in a Word file.

Looks like my add-in is not the only add-in that's had problems with this:
http://support.microsoft.com/kb/960806
http://support.microsoft.com/kb/2021065

Still working on a fix. Will keep you posted.

Coordinator
Sep 2, 2011 at 2:59 AM

This code appears to be the trick to solve this problem. I'll look into implementing this in OLAP PivotTable Extensions.

http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/04/11/excel-ole-embedding-errors-with-managed-addin.aspx

Thanks for reporting this issue. I'll post back here as I make progress.

Coordinator
Sep 3, 2011 at 3:35 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Coordinator
Sep 14, 2011 at 4:25 PM

This fix is in release 0.7.2, which is currently in beta. Please go to the Downloads tab, then click 0.7.2 on the top right. Please test this out and let me know whether it fixed the problem for you.

Marked as answer by furmangg on 6/10/2014 at 3:40 AM
Sep 27, 2011 at 10:26 PM

Yes.. I had a couple people test it..  It works now.. thanks !