SQL SERVER – Enable PowerPivot Plugin in Excel

Recently I had interesting experience at one conference. My PowerPivot plugin got disabled and I had no clue how to enable the same. After while, I figured out how to enable the same. Once I got back from the event, I searched online and realize that many other people online are facing the same problem. Here is how I solved the problem.

When I started Excel it did not load PowerPivot plugin. I found in option>> Add in the plug in to be disabled. I enabled the plugin and it worked very well. Let us see that with images.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

6 thoughts on “SQL SERVER – Enable PowerPivot Plugin in Excel

  1. HI Pinal!
    Good timing with your blog! :) I’ve just installed PowerPivot for Excel but I can’t make it work.

    I both done it according to Microsofts webb site and you’re instructions above.

    Any other tips besides the one’s above?

    Ps. Great blog!



  2. Thanks Pinal, With newer releases of the office suite, I am also finding that options and features are kind of buried inside. I guess it takes while to get used to new interface of MS office products.


  3. Just a small tip – we have found add-ins (like PowerPivot, and a custom add-in deployed by the application I work on) to get disabled if Office experienced a crash or if it did not have enough memory to load all add-ins in memory. Enabling the add-in might resolve the issue for a couple of sessions, untill the underlying issue returns (a crashing macro, code or insufficient memory).

    Thanks & Regards,
    Nakul Vachhrajani.

    Be courteous. Drive responsibly.


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s