SOLVED

Power Pivot disappeared after reset Registry and not showing in COM add-ins in Microsoft Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-3073225%22%20slang%3D%22en-US%22%3EPower%20Pivot%20disappeared%20after%20reset%20Registry%20and%20not%20showing%20in%20COM%20add-ins%20in%20Microsoft%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073225%22%20slang%3D%22en-US%22%3E%3CP%3EDears%2C%3C%2FP%3E%3CP%3EI%20contacted%20MS%20support%20for%20an%20issue%20regarding%20slow%20Power%20Query%20refresh.%20They%20requested%20to%20remote%20control%20my%20PC%20then%2C%20as%20a%20try%20to%20solve%20the%20issue%2C%20they%20reset%20Excel%20setting%20by%20deleting%20its%20Registry%20data.%3C%2FP%3E%3CP%3EThe%20issue%20has%20not%20solved%20but%20I%20noticed%20later%20that%20I%20lost%20access%20to%20Power%20Pivot%20and%20it%20is%20not%20showing%20in%20COM%20add-ins%20list%20as%20well%3C%2FP%3E%3CP%3EI%20have%20tried%20Repair%20Microsoft%20356%20(Quick%20Repair%20and%20Online%20Repair)%20and%20it%20didn't%20resolve%20the%20issue.%3C%2FP%3E%3CP%3ENoting%20that%20Power%20Pivot%20add-in%20folder%20is%20exist%20in%20(%3CEM%3EC%3A%5CProgram%20Files%5CMicrosoft%20Office%5Croot%5COffice16%5CADDINS%3C%2FEM%3E)%20as%20shown%20below%3C%2FP%3E%3CP%3EI%20have%20Microsoft%20365%20Family%20subscription%20version%20(%3C!--%20%20StartFragment%20%20%20--%3E%3CSTRONG%3E%3CSPAN%20class%3D%22%22%3EMicrosoft%C2%AE%20Excel%C2%AE%20for%20Microsoft%20365%20MSO%20(Version%202112%20Build%2016.0.14729.20254)%2064-bit%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C!--%20%20EndFragment%20%20%20--%3E)%20on%20PC%2FWindows%2010%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20COM%20addins.PNG%22%20style%3D%22width%3A%20906px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342786iECCC1B499C60A978%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Excel%20COM%20addins.PNG%22%20alt%3D%22Excel%20COM%20addins.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20addins%20folder.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342787i49422A5A31C82F26%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Excel%20addins%20folder.PNG%22%20alt%3D%22Excel%20addins%20folder.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3073225%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3082968%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20disappeared%20after%20reset%20Registry%20and%20not%20showing%20in%20COM%20add-ins%20in%20Microsoft%20Excel%203%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3082968%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1263958%22%20target%3D%22_blank%22%3E%40Mustafa_q%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CP%20class%3D%22%22%3EAfter%20submitting%20my%20post%2C%20I%20searched%20online%20again%20and%20I%20return%20to%20a%20MS%20support%20article%3C%2FP%3E%3CDIV%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fstart-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fstart-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20read%20it%20again%20and%20found%20that%20the%20following%20Registry%20key%20is%20exist%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EComputer%5CHKEY_CURRENT_USER%5CSOFTWARE%5CMicrosoft%5COffice%5C16.0%5CUser%20Settings%5CPowerPivotExcelAddin%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20deleting%20it%2C%20I%20found%20PowerPivot%20returned%20to%20COM%20add-ins%20list.%20After%20enabling%20it%2C%20%3CSTRONG%3Eit%20worked%20fine%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EThanks%20to%20anyone%20read%20my%20post%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

 

Excel COM addins.PNGExcel addins folder.PNG

 

1 Reply
best response confirmed by Mustafa_q (New Contributor)
Solution

@Mustafa_q 

After submitting my post, I searched online again and I return to a MS support article

 

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