PowerPivot for Excel 2013 can't be loaded

Question

I had to have my computer re-imaged and had Microsoft Office 2013 Professional Plus reinstalled. Now when I try to start PowerPivot I get this error (see attached for picture). Method not found: Microsoft.AnalysisServices.Common.ApplicationEdition Microsoft.AnalysisServices.Common.IModelerHost.get_ApplicationEdition().

I have tried Office Repair like it suggested a couple of times but have had no luck

Answer 1

It's possible that the .Net framework needs repair.
https://www.microsoft.com/en-us/download/details.aspx?id=30135

--please don't forget to Accept as answer if the reply is helpful--

Answer 2

Hi @Miranda Klug ,
Please go to File- Account and provide the detail version of Excel you're using:

Not all versions of PowerPivot is available in Excel.

I also suggest you try this method:

• Start Excel in Safe Mode ( run: excel \safemode)
• Alt - F11 (opens VBA editor)
• Tools > references
• Un-checked the following:
  OLE Automation
  Microsoft Office 16.0 Object Library
• 'Save As'
• Re-open workbook normal and check the result.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Some other ideas here.
https://social.msdn.microsoft.com/Forums/en-US/d3924a5d-f337-48e6-8418-cb7c72f4d87f/powerpivot-exception-while-saving-could-not-load-file-or-assembly?forum=sqlkjpowerpivotforexcel

--please don't forget to Accept as answer if the reply is helpful--