Excel: Why Isn't Power Pivot Tab in the Ribbon?

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.


Problem: I have a version of Excel 2013 that is supposed to have Power Pivot, Power View, Power Map, Power Query, but they are not in the ribbon.

Strategy: Go to File, Options, Add-Ins. In the bottom of the dialog open the Manage dropdown and choose COM Add-ins. Click Go"¦

Add checkmarks to Microsoft Office PowerPivot for Excel 2013, Microsoft Power Query for Excel, Power View for Excel Add-In,