Can't get PowerPivot to show up in excel

Question

I have uninstalled office 2010 and Powerpivot, reinstalled per forum comments and still nothing. I do have .NET 4 installed. Any ideas?

1. Open Excel and select File->Options->Addins->Manage COM addins.
2. Put a checkmark in the box for the PowerPivot for Excel addin and click OK.

I have also tried

• Click on the Environmental Variable
• Click on New User Variable
• Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
• Nothing!

Answer 1

Hi,

i'm having the same problem, did you ever solve it?

thanks!!

---

Raul Queiroga, Microsoft Partner and MCP

Answer 2

1) make sure you have office shared and Office tools selected in the Office installation

2) Can you try repairing .Net 3.5, restart the box and try again?

 

---

Thanks, Deva [MSFT] My blog: http://powerpivot.spaces.live.com/

Answer 3

Hi Deva,

my office instalation has all the components and I have .net 4.0 and not 3.5...chould I try reparing it? I already tried the VSTO_SUPPRESSDISPLAYALERTS flag and reainstalling the powerpivot addin completely, and nothing..

thanks for your reply

---

Raul Queiroga, Microsoft Partner and MCP

Answer 4

Hi Raul, If you are using PowerPivot (SQL Server 2008 R2) 10.50.*.* then you need to have .net 3.5 and pick Office Shared Tools and Office Tools entirely while installing Excel. If you are using PowerPivot 11.0.* CTP2 (Code named Denali) then .Net 4.0 and VSTO for .Net 4.0.

Hope this helps!

 

---

Thanks, Deva [MSFT] My blog: http://powerpivot.spaces.live.com/