Office 2013 Business Intelligence Add-in’s
PowerPivot and Power View are two of the most touted and demoed tools from the Microsoft Business Intelligence 2012 stack. You may have heard that Excel 2013 includes both of these add-ins by default. You’ve fired up that new copy of Excel and are wondering where the heck are they? Well, the add-ins are installed by default but they are not enabled. Here’s is how to enable them:
1. Open Excel 2013
2. Click on File:
3. Click Options:
4. Click Add-Ins:
5. Change Manage to Com Add-ins and click the Go button.
6. Ensure both Microsoft Office PowerPivot for Excel 2013 and Power View are checked and then click OK. (Why one has such a long and stuffy name while there other one is much more informal, I have no clue. Why one has a space between Power and Verb and the other one doesn’t is another mystery to me).
7. If enabled, you’ll find PowerPivot on the Home ribbon:
You’ll find Power View under Insert: