Excel: Open the Power Pivot Window

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


There is a PowerPivot tab in the Excel ribbon. In Excel 2013, click the Manage button to open PowerPivot. In Excel 2010, click the PowerPivot Window icon to open PowerPivot.

  1. Although Excel offers a PowerPivot ribbon, most commands are inside of Power Pivot.