Try the Excel Course for Free!

Enable Power Pivot in Excel – Instructions

/ / Excel for Office 365, Latest, Microsoft, Office 365

Enable Power Pivot in Excel: Video Lesson

            This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Enable Power Pivot in Excel,” shows you how to enable Power Pivot in Excel by enabling the Data Analysis add-ins in Excel for Microsoft 365. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™.

Overview:

            This lesson shows you how to turn on the Data Analysis add-ins in Excel, which lets you enable Power Pivot in Excel for Microsoft 365. To enable the data analysis add-ins in Excel for Microsoft 365, which enables Power Pivot and 3D Maps at once, click the “File” tab in the Ribbon to open the backstage view. Then click the “Options” category at the left side of the backstage view to open the “Excel Options” window.

            Then click the “Data” category at the left side of the “Excel Options” window. At the right side of this window, under the “Data options” section, check the “Enable Data Analysis add-ins: Power Pivot and 3D Maps” checkbox. Then click the “OK” button in the lower-right corner of the “Excel Options” window to enable those two add-ins.

Enable Power Pivot in Excel - Instructions: A picture of a user enabling the Data Analysis add-ins within the “Excel Options” window in Excel for Microsoft 365.

            You should then see a new “Power Pivot” tab appear within the Ribbon. You can click this tab in the Ribbon to view the commands used to manage your Power Pivot data in Excel.

Instructions on How to Enable Power Pivot in Excel:

  1. To enable Power Pivot in Excel for Microsoft 365 by enabling the Data Analysis add-ins, click the “File” tab in the Ribbon to open the backstage view.
  2. Then click the “Options” category at the left side of the backstage view to open the “Excel Options” window.
  3. Then click the “Data” category at the left side of the “Excel Options” window.
  4. At the right side of this window, under the “Data options” section, check the “Enable Data Analysis add-ins: Power Pivot and 3D Maps” checkbox.
  5. Then click the “OK” button in the lower-right corner of the “Excel Options” window.
  6. To then view the commands for Power Pivot in Excel, click the new “Power Pivot” tab that appears in the Ribbon.
TOP