Excel 2013 – Where is PowerPivot?

I just installed Office 2013 – where did PowerPivot go? Well, it isn’t a download that you need to find and install now. Rather, it is an Add-In that you need to enable.

  1. Open Excel
  2. File -> Options -> Add-Ins
  3. Under “Inactive Application Add-ins” you will notice that PowerPivot is listed. Hence, it is “Inactive” post install.

  1. Since it is listed as a “COM Add-in”, Manage COM Add-ins at the bottom of this screen, and click “Go…”
  2. Here you can modify the state of the Add-in. Check the box and click “OK”. While you are at it, I would also suggest enabling “Power View” for visualizations.

Why you cannot just toggle the Add-ins from inactive to active without the “manage” step is a bit odd, but it works. Perhaps in the future they will let you double click, right click, check a box, or just drag the add-in to the other area without this extra step.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: