Hi,

I have performed a Windows 10 upgrade on a machine. However we have noticed that Powerpivot 2010 (SQL2012 SP2) 64bit addon will not load.

Microsoft Excel
Excel experienced a serious problem with the 'powerpivot for excel' add-in. If you have seen this message multiple times, you should disable this add-in and check to see if an update is available. Do you want to disable this add-in?
P1: 700160
P2: 14.0.7015.1000
P3: 
P4: 

I have tried all of the usual things. uninstalled Office, Powerpivot, Deleted the c/Program Files/Microsoft Analysis Services folder.

No luck. Is this a known / repeatable issue? - We were having no issues at all with Windows 7 SP1. Thanks

Jamie

I also have found the same issue within the last couple of hours after upgrading to Windows 10. Called MS Support and they wanted me to initiate a support ticket and start paying for a solution.  Running W-10 with Office 2010 and PowerPivot and Power Query. Absolutely no problems prior to the upgrade while running W-8.1.

I also tried uninstall and reinstall with no luck.

Dennis

Dennis, 

Thanks, at least I am not the only one. Hopefully they are working on a fix? Anyway to bring this to the attention of someone more senior in Microsoft?

Hi Jamie Olney,

As far as I know, if we want to load the Power Pivot, we need some development components that installed on the OS, such as Visual Studio 2010 Tools for Office Runtime. Please make sure you have installed or upgraded them in Windows 10.

Then, please install the latest Office update patches and check if it is helpful.

Hope it's helpful.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

This morning, I have set up a new virtual Windows 10 machine in VirtualBox. Clean machine except for Office 2010. Installed Office Service Pack 2 and installed available updates. Installed C++ as above, except for the 2005 entry, and "PowerPivot_for_Excel_amd64". Still get the following error when opening Excel.

Anyone have any further ideas to try? Thanks.

Dennis

Hi George,

I can confirm that Visual Studio 2010 Tools for Office Runtime is installed. - Remember I just did an upgrade from Windows 7 & have since uninstalled & reinstalled Office & Powerpivot including Tools for Office Runtime completely.

Dennis - Thanks for confirming that it also happens on a clean install. Hopefully this should mean it will now be a known issue. 

Thanks

Jamie

Hi George,

I am facing the same issue, and have most of the VSTO redistributable except for 2005.

Was on Win7 64bit and no issues with PowerPivot Add-in until I upgraded to Win10.
Interestingly the lower version of PowerPivot (SQL Server 2008 R2) would not crash.

Also tried uninstall/reinstall but no help :<

Hi,

Please try this method and check if it is helpful:

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

Reference:

https://social.technet.microsoft.com/Forums/office/en-US/f8e65ee1-7802-432b-80f7-a8d1879dfbd8/excel-2013-powerpivot-addin-crashes?forum=excel

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

George,

I just tried your suggestion above and it did not work.  The referenced TechNet item appears to be addressing an issue when working with DAX after loading the Excel 2013 worksheet.  We cannot even get Excel 2010 to load with PowerPivot.

Dennis

Jamie,

This worked for me on my Windows 10 virtual machine. Grabbed it from a post I made on the Windows forum.

This worked for me.
1) Search for regedit via button beside Windows Key, Run regedit
2) Navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework
3) Right click on .NETFramework, select New > DWORD (32-Bit)
4) Name it useLegacyJit (without the inverted commas)
5) Right click the newly created item >
Modify > Enter 1 in the Value data field, (Base should remain as HEX) Press OK
6) Restart PC (Not sure why but without this step Add-In still wont work)
7) Launch Excel, then > Options >
Add-ins > Manage Disabled Item > Select PowerPivot > Enable > Close
8) Close Excel completely and launch it, and I see PowerPivot again!

Thanks to Charles of PowerPivotPro.com for redirecting the solution
http://forum.powerpivotpro.com/forums/topic/power-pivot-add-in-crashes-excel-2010-in-windows-10/

Dennis

• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, August 06, 2015 1:05 AM
• Marked as answer by Jamie Olney Thursday, August 06, 2015 10:30 AM

Jamie,

This worked for me on my Windows 10 virtual machine. Grabbed it from a post I made on the Windows forum.

This worked for me.
1) Search for regedit via button beside Windows Key, Run regedit
2) Navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework
3) Right click on .NETFramework, select New > DWORD (32-Bit)
4) Name it useLegacyJit (without the inverted commas)
5) Right click the newly created item >
Modify > Enter 1 in the Value data field, (Base should remain as HEX) Press OK
6) Restart PC (Not sure why but without this step Add-In still wont work)
7) Launch Excel, then > Options >
Add-ins > Manage Disabled Item > Select PowerPivot > Enable > Close
8) Close Excel completely and launch it, and I see PowerPivot again!

Thanks to Charles of PowerPivotPro.com for redirecting the solution
http://forum.powerpivotpro.com/forums/topic/power-pivot-add-in-crashes-excel-2010-in-windows-10/

Dennis

• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, August 06, 2015 1:05 AM
• Marked as answer by Jamie Olney Thursday, August 06, 2015 10:30 AM

Hi Dennis,

Brilliant, thanks for that. That works great.

Jamie

Hi, Dennis

Thanks. It works on my computer

Fuxinng