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.

SQL SERVER - Enable PowerPivot Plugin in Excel pp1

SQL SERVER - Enable PowerPivot Plugin in Excel pp2

SQL SERVER - Enable PowerPivot Plugin in Excel pp3

SQL SERVER - Enable PowerPivot Plugin in Excel pp4

SQL SERVER - Enable PowerPivot Plugin in Excel pp5

SQL SERVER - Enable PowerPivot Plugin in Excel pp6

SQL SERVER - Enable PowerPivot Plugin in Excel pp7

Reference: Pinal Dave (https://blog.sqlauthority.com)

PowerPivot
Previous Post
SQL SERVER – Running Multiple Batch Files Together in Parallel
Next Post
SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)

Related Posts

6 Comments. Leave new

  • 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!

    Regards,
    Shakir

    Reply
  • 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.

    Reply
  • Nakul Vachhrajani
    May 21, 2011 7:50 pm

    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.

    Reply
  • Thank you for your answer.

    Regards
    Mr. Jirachod

    Reply
  • Hi,
    Same case happened to me. i quickly soved it with your help.

    Thank you.

    Reply
  • Thank you – this really helped.

    Reply

Leave a Reply