Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which is available in labs or you can download for free. You can also easily Import Excel workbooks into Power BI Desktop. |
If you do not find Power View on the Ribbon, you need to enable the Power View add-in.
Click the File tab on the Ribbon.
Click Options.
Click Add-Ins in the Excel Options dialog box.
Click the drop-down arrow in the Manage box.
Select COM Add-ins from the dropdown list and click Go.
The COM Add-ins dialog box appears. Check the box Power View and click OK.
Power View will be visible on the Ribbon.
In the Ribbon window, right-click Data group and select Customize the Ribbon.
In the Choose commands from list, change the selection from Popular Commands to All Commands.
Scrolldown and select Power View from the list.
Click Add. Make sure to select the custom Power View as the destination.
To see and save your changes, click OK.