Addin won't show in Excel 2010

Question

I have just installed the PowerPivot x86 add-in i downloaded from powerpivot.com. I installed excel from "en_office_professional_plus_2010_beta_x86_x16-19227" from msdn. But now the add-in won't show up in Excel, both installs went ok without a warning.

Can anybody help me?

Answer 1

Could you check File - Options - Add Ins and see if Microsoft.AnalysisServices.Modeler.FieldList.Addin.Integration is listed as an active Add In?

Wesley Backelant - MSFT
http://blogs.msdn.com/wesleyb
http://twitter.com/WesleyBackelant
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

I have the Microsoft.AnalysisService.Modeler.Fieldlist.Addin.Integration addin installed but it is stated as inactive.

Answer 3

Ok, could you try to enable it?  Select "Disabled Items" in the dropdown at the bottom and press Go to get a list of disabled items (in the Add In dialog).

Wesley Backelant - MSFT
http://blogs.msdn.com/wesleyb
http://twitter.com/WesleyBackelant
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 4

It's not at the disabled items, It's at the inactive items. When i go to Com Addins and check the "Microsoft.AnalysisService.Modeler.Fieldlist.Addin.Integration" nothing happens.

But when i go to the Com Addins a second time a message "Not Loaded. The managed add-in loader failed to initialize."

I run on Server 2008 with SP2 on Excel x86.

Answer 5

Have you installed the prereqs like .NET Framework 3.5 SP1?
Is .NET Programmability Support installed for Excel (Add/Remove Programs / Change Office 2010 / check under Excel)?


Wesley Backelant - MSFT
http://blogs.msdn.com/wesleyb
http://twitter.com/WesleyBackelant
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 6

I have installed both prereqs

Answer 7

can you try setting global environment variable VSTO_SUPPRESSDISPLAYALERTS  to 0 and restart Excel, then paste the error message here?

---

-- This posting is provided "AS IS" with no warranties, and confers no rights

Answer 8

Based on the error message you are seeing, I believe you have only installed Excel when you installed office.  For Office Beta 2 / PowerPivot CTP3, you need to also install Office Shared Tools feature when you install Office.  You should:

1. Uninstall PowerPivot
2. Uninstall Office
3. Reinstall Office, specifying at least Excel + Office Shared Tools
4. Reinstall PowerPivot

Thanks,
-Ron Pihlgren [MSFT]

Answer 9

Thx Ron ! that did it !