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.
Enabling Power View Add-in
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.
Add commands to a custom group
In the Ribbon window, right-click Data group and select Customize the Ribbon.
- Select New Group on the right and create a new group, Rename it to Power View.
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.