I created a short table in Excel 2013, positioned the cursor in the table and clicked Inset/Power View Report. I get a status window saying Excel is opening a Power View sheet but then I get a Power View error: Cannot Insert Object. I am able to insert new tabs in the workbook. When I try the insert again, I just get the Power View error. I looked at other threads with similar issues and did the following:

Made the Formula bar visible - no change

Tried to repair Office 2013 but that option is not available when I right click on the program in the Control Panel

De-installed Silverlight - Tried to insert Power View Report. A Power View tab was created with the Power View picture and Power View ribbon. Got the message to install Silverlight and Reload. Installed Silverlight hit Reload and the Power View tab didn't change. Hit Power View Report and got the Cannot Insert Object error message again.

Any help is appreciated.

Hi,

Did you use PowerView first time? I notice you had found a similar thread and tested the solutions.

PowerView is an add-in in Excel2013, We must make sure that you check some option in the trust center and Add-in center.

http://blogs.office.com/b/microsoft-excel/archive/2012/10/04/intro-to-power-view-for-excel-2013.aspx

Location1: Excel Options>Add-in>Solver Add-in enable

Location2: Excel Options> Trust Center> Add-in

Then you said that you couldnt repair the Excel 2013, please refer to the following link:

http://office.microsoft.com/en-gb/outlook-help/repair-office-programs-HA010357402.aspx

At last, we may test it in clean boot, please refer to the following link:

http://support.microsoft.com/kb/929135

Regards,

George Zhao
TechNet Community Support

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, September 20, 2013 5:16 AM

Hello,

Did you solve this? I am seeing the same issue and there are no solutions anywhere I search.

Thanks

Hi everyone,

I'm encountering the same issue. Is there anyone who can shed some light here?

Thanks!

Yes I am having the same issue-

Office 2013 32bit on a 64 bit Windows 7 system

suggested by George Zhao:

Location1: Excel Options>Add-in>Solver Add-in enable- I just enabled that still getting the error

Location2: Excel Options> Trust Center> Add-in-not sure what if anything I need to select here-none of the three options are currently selected

I get the same error as above 'can't insert object' I am also getting the error "exception from HResult: 0x800401A8"

I never got a prompt to install Silverlight? Silverlight is version 5.1.20913.0

Any help would be appreciated!!

Hi!

Same problem here. Would like to add that it Works as local admin, so you might wanna try that. Our Security policy does not allow users to have local admin permissions.

Any other sollutions?

Hi again,

It had nothing to do with local admin permissions. It seems like Power View require ActiveX to run. We had the Office 2013 GPO Security setting "Disable All ActiveX" enabled. If you disable or change this to Not configured it work fine.

• Proposed as answer by Frode E Wednesday, January 21, 2015 11:56 AM

Thanks so much!

This worked for me :)

Kind regards,

Nerea

Fix for me was to enable active content. The gpo wasn't set but the document was locked.  I had no yellow bar telling me activex had been disabled or document was untrusted but followed the instructions below and all fixed now. Hope this helps someone.

Another method to enable ActiveX controls in a file is via the Microsoft Office Backstage view, the view that appears after you click the File tab, when the yellow Message Bar appears.

1. Click the File tab.

2. In the Security Warning area, click Enable Content.

3. Under Enable All Content, click Always enable this document's active content.
   The file becomes a trusted document