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.

 

[Smither]

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

Okay, I've located ADDINS using this.

 

[sandy666]

read post #9 especially under the picture

 

[Fluff]

Okay, I've located ADDINS using this.

Do you see something like

 

[Smither]

Do you see something like
View attachment 9563

Yes

 

[sandy666]

I'll post again

Enabling Power Pivot for Office Home and Business 2016

social.technet.microsoft.com

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

you can try download add-in for 2010/2013 and try to install but I don't want to be responsible if something wrong will happen ?

 

[Fluff]

Hi Sandy it seems that link is out of date, but you're right it's not available.

Where is Power Pivot? - Microsoft Support

Learn which Office versions come with Power Pivot

support.office.com

 

[Smither]

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

check this
View attachment 9560

I do see this.

 

[sandy666]

Hi Sandy it seems that link is out of date, but you're right it's not available.

Where is Power Pivot? - Microsoft Support

Learn which Office versions come with Power Pivot

support.office.com

Hi Fluff,
sure but MS , imho, never update older version for new features , especially limited version like H&B. They prefer upgrade to newer (money)

 

[sandy666]

@Smither

1. open COM add-ins
2. click Add
3. go to the dll you found and select this
4. ok

and we will see what will happen

 

[Smither]

@Smither

1. open COM add-ins
2. click Add
3. go to the dll you found and select this
4. ok

and we will see what will happen

I get this.