Power pivot add in

[Vaggelis365]

Hello,

I tried to add in the power pivot. I followed all steps in order to activate the add in but unfortunately doesn't work. In the bar i have the option power pivot but when i click on this the other option(manage,measure etc.) is not activate.

How can i fix it?

[#2]

@Vaggelis365 

On which Excel you are, is it in the list here Where is Power Pivot? - Microsoft Support ?

[#3]

Yesterday I made a subscription for the home office 2021 which is on the list.

If i have the wrong excel then would i install the pivot ad in in the bar?

[#4]

@Vaggelis365 

If I may add this additional information...

Start the Power Pivot add-in for Excel

Power Pivot is an add-in that you can use to perform powerful data analysis in Excel.

The add-in is built into certain versions of Office, but by default, it's not enabled.

How to Install Power Pivot in Excel?

I hope this helps!

[#5]

@Vaggelis365 

Other words you see it in File->Options->Add-ins->COM add-ins, correct?

[#6]

Yes, but i dont have the first two option. I click power pivot for excel. Also form the data i chose enable data with power pivot.

[#7]

@Vaggelis365 What "first two options" are? Power Pivot exists or doesn't exist. You may only activate it (or deactivate), you can't install it as external add-in.

[#8]

@SergeiBaklan 

  I made these steps. When I m going to the toolbar, I have the power pivot choice but still i can not use it.

 

[#9]

@Vaggelis365 

PowerPivot controls disabled with non-default Excel file format

Maybe it will help...if not just ignore it.

[#10 · Accepted solution]

@Vaggelis365 

Could you please try PowerPivot controls disabled with non-default Excel file format - Office | Microsoft Learn

[#11]

Thank you so much!

Now its ok, i can use the tools!
Best Regards!

[#12]

@Vaggelis365 

Great to know you sorted this out, thank you for the update.

[#13]

No Microsoft Power Pivot

[#14]

@ssaintlouis 

It's not available on your platform, or, if available, you didn't activate it. 

[#15]

@SergeiBaklan 
I have a subscription to Microsoft Office 365. The default version is installed. So far, I have not been able to find PowerPivot as a feature in Excel. 

[#16]

@ssaintlouis 

Strange. On which channel you are? You may find in File->Account

[#17]

@SergeiBaklan  

[#18]

@ssaintlouis 

Have no other ideas but if something is wrong with registry. You may try to play with it manually, some keys are mentioned here COM add-ins are not displayed in the COM Add-Ins dialog box - Microsoft 365 Apps | Microsoft Learn. However, more safe to try Office reinstallation.

Online repair shall save all your Office settings, but not always help. Office support tool Repair an Office application - Microsoft Support works as clean installation.

[#19]

I followed all of that, but nothing has work so far. I still can't find the Power Pivot feature. I have uninstalled Microsoft 365 and Office with this Microsoft tool and tried all the versions: The 32-bit, the 64-bit, and default one. So far, I haven't been satisfied. When I go to the COM Add-ins option, the Power Pivot feature I want to use is still missing in the Excel 365 application to witch I have a subscription.