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]

@Sergei Baklan 

  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.