Forum Discussion
Power Pivot disappeared after reset Registry and not showing in COM add-ins in Microsoft Excel 365
Dears,
I contacted MS support for an issue regarding slow Power Query refresh. They requested to remote control my PC then, as a try to solve the issue, they reset Excel setting by deleting its Registry data.
The issue has not solved but I noticed later that I lost access to Power Pivot and it is not showing in COM add-ins list as well
I have tried Repair Microsoft 356 (Quick Repair and Online Repair) and it didn't resolve the issue.
Noting that Power Pivot add-in folder is exist in (C:\Program Files\Microsoft Office\root\Office16\ADDINS) as shown below
I have Microsoft 365 Family subscription version (Microsoft® Excel® for Microsoft 365 MSO (Version 2112 Build 16.0.14729.20254) 64-bit) on PC/Windows 10
After submitting my post, I searched online again and I return to a MS support article
https://support.microsoft.com/en-us/office/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8
I read it again and found that the following Registry key is exist
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\User Settings\PowerPivotExcelAddin
After deleting it, I found PowerPivot returned to COM add-ins list. After enabling it, it worked fine
Thanks to anyone read my post
1 Reply
After submitting my post, I searched online again and I return to a MS support article
https://support.microsoft.com/en-us/office/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8
I read it again and found that the following Registry key is exist
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\User Settings\PowerPivotExcelAddin
After deleting it, I found PowerPivot returned to COM add-ins list. After enabling it, it worked fine
Thanks to anyone read my post