PivotPower Free Excel Add-in

Do you use the free Pivot Power add-in that’s available on my Contextures website? I created Pivot Power to make my own work easier to do, and shared it on my website to help you with your pivot table tasks.

It automates some of the features that aren’t built in to an Excel pivot table, and makes some of the buried Excel pivot table features easier to access.

For example, there is a command that changes all the data fields to SUM, which is handy when Excel defaults to COUNT.

pivotpowersum01

Get Free Pivot Power Add-In

Click here to go to the download page for this free add-in is still available, and try it out!

_______________

0 thoughts on “PivotPower Free Excel Add-in”

  1. Hi Debra, this is awesome. I’ll give the free version a shot and come back for the premium version later. When I hear pivot I always think “Debra” *ggg*

  2. Loving the pivot power premium!! Debra, do you think it would be possible to tie some of my favourite commands to hot keys? Or perhaps link them to a button on the custom ribbon?

    1. Thanks Jaffey, I’m glad you like it! After you unlock the VBA project, you should see the PivotPower Premium macros in the list, if you customize the Quick Access Toolbar or the Ribbon (Excel 2010).
      Also, you can click the Macros command on the Developer tab, and type a macro name in the box, then click Options, to create a shortcut key.

  3. Hello Debra,
    Just few words to congratulate you for your add’in very usefull and very instructive, as besides all your blog.
    My “dream” is to be able to set up a new userform allowing to manage number formats (decimals, right offset, currency symbol, zero display …), synthetis type (sum, count …) and also “graft” some of my own tools (eg extensible definition of the range with offset function …).
    A day will come …
    Best regards

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.