How to Enable Power Pivot and Power View in Different Versions of Microsoft Excel

First of all, you should have the right version of Excel. There are many Excel Version where Power Pivot is not available, So No matter what you do, you will not be able to Enable Power Pivot There.

For e.g. Power Pivot is currently NOT available in office Version of Mac or Android or Office for Home & Student / Business 2013-2016 etc.  So, you cannot enable Power Pivot in these Excel Version. Please do not waste your effort trying to find out a You Tube video to do so. So first of all, check what version of Excel are you using.

Where to Check the Excel Version – Open Excel, Go To File → Account

  • If you are using Microsoft Excel 2010, then you have free download add In available for Power Pivot. The Power Pivot add-in for Excel 2010 did not ship with Office, but is available as a free download :   - https://www.microsoft.com/en-us/download/details.aspx?id=43348

  • This free download works only with Excel 2010, and not with newer versions of Excel.

 

If you want to get the Latest detailed list of Version of Excel where Power Pivot is available or not available, go on Google and search “Where is Power Pivot?”  









 

What versions of Microsoft Office include Power Pivot?








 

Power Pivot is NOT included with any of the following:





 

How To Enable Power Pivot If its already present as an Add-In

  • To enable the Power Pivot or Power Query  plug-ins to access the tools (File > Options > Add-Ins > Manage: COM Add-Ins)

Click on the Power Pivot , Power View & Power Map add ins available based on your version of Excel  

 

Next How To Enable Power View

  • Power View Must be available as an add in based on your Version of Excel

  • Even after its available in order to see the Power View Button on your Excel, Follow the Steps below.



 

  1. Go to File Options Customized Ribbon

 

 

2. Inside Customized Ribbon Choose Commands from 1. All Commands, 2. Power View

  1. On the Right hand side , Click on 1 + button next to “Insert” , then click on 2 - “New Group” and then 3 - Rename it to 4-“PowerView” and then 5- click “OK”

 

  1. Then Select Power View on the Left Hand Side and move it to right hand side below the new Group We Created and click ok

 

5.After this Power View is Enabled and you can see it inside your “Insert” Ribbon in Excel

 

 

 

So this concludes the Blog on How to Enable Power Pivot , Power View in Microsoft Excel . If you are looking for Corporate Training at your Organization to get your workforce up and running on the latest features of Microsoft Power Query , Power Pivot , Power Map , Power View and all in one - Microsoft Power BI Desktop Application along with Microsoft Power BI Service Free and Pro licence contact at akriti.lal@instrovate.com or whatsapp at +91-9953805788 

 

 

Comments

There are no entries yet.
Please enter the code
* Required fields

Subscribe to our mailing list

* indicates required

Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 

 

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more . 

 

  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher
Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail