Installing Power Pivot tab in Excel

[Smither]

I have followed the first step 1 and then step 2 at the link below.

It states:

" Here’s how you enable Power Pivot before using it for the first time.

1. Go to File > Options > Add-Ins.

2. In the Manage box, click COM Add-ins> Go.

3. Check the Microsoft Office Power Pivot box, and then click OK. If you have other versions of the Power Pivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the Power Pivot add-in for Excel.

The ribbon now has a Power Pivot tab. "

Start the Power Pivot add-in for Excel - Microsoft Support

Power Pivot in Microsoft Excel is an add-in you can use to perform powerful data analysis in Excel. Here’s how you enable Power Pivot before you use it for the first time.

support.office.com

However, I see what's in the attached image. This has a tick box for "Power Map", but not for "Power Pivot". Any ideas as to why this is the case? Thanks.

 

[sandy666]

what is you Excel version?
from this picture I see you've 2016 or higher so you have Power Pivot built-in

 

[Smither]

Thanks sandy666. It's version 2016.

I have a Developer tab, though no Power Pivot tab.

 

[sandy666]

It's version 2016.

so update your profile about Excel version (read my third bottom line)

check this

 

[Smither]

Thanks - when I get to Program Files the only next similar option which I have is Microsoft Office 15, not Microsoft Office followed by Office 16.

When I go into Office 15, I see ClientX64 and v32, I don't see ADDINS.

 

[sandy666]

How do you know you've 2016 ?
maybe it is for students version or something like that (limited)

check this

maybe this add-in is disabled by mistake

 

[Smither]

If I click on FIle followed by Account it states "Microsoft Office Home and Business 2016".

Where is the drop-down located which you have shown?

 

[Fluff]

hen I get to Program Files the only next similar option which I have is Microsoft Office 15,

Have a look in C:\Program Files (x86)\Microsoft Office\root\Office16\ADDINS

 

[sandy666]

did you read whole article about

Start the Power Pivot add-in for Excel - Microsoft Support

Power Pivot in Microsoft Excel is an add-in you can use to perform powerful data analysis in Excel. Here’s how you enable Power Pivot before you use it for the first time.

support.office.com

but I'm afraid, Power Pivot is not available for Home & Business version

Enabling Power Pivot for Office Home and Business 2016

social.technet.microsoft.com

you may upgrade your version to Pro version

 

[Smither]

How do you know you've 2016 ?
maybe it is for students version or something like that (limited)

check this
View attachment 9561
maybe this add-in is disabled by mistake

I've found this, when I click here it states "There are no disabled items".