Contextures Pivot Power Free Add-in Update

Pivot Power Free Add-in Update

A new version of my Excel Pivot Power Free add-in is available. There’s one new feature, a fix, and a couple of minor changes in the background.

Pivot Power Free

If you haven’t heard about it before, my Excel Pivot Power Free add-in  (PPF) has a few tools that help you automate basic pivot table tasks. For example:

  • Change all the numbers from Count to Sum
  • Make a list of all the pivot tables in the active workbook
  • Format all the numbers with zero decimals

Useful Pivot Table Tools

Pivot Power Free is perfect for people who don’t use pivot tables too often, and just want a few useful tools. Learn more about it, to see if it’s what you need.

The PPF add-in is a mini version of the Pivot Power Premium (PPP) add-in, which is for pivot table power users only. Most people don’t need all the tools that PPP has!

Pivot Power Free Tools

Here’s what the PPF Ribbon tab looks like.

At the left, there are formatting tools, function tools, and pivot table settings.

At the right, there are pivot table information tools, workbook settings, and links to pages on my Contextures site.

Go to the Pivot Power Free page, to learn a bit more about the tools that it has.

Pivot Power Free Update

On Monday, I released Pivot Power Free Version 2.00. There were a few changes:

  • one new feature
  • one feature fix
  • minor changes in the background

The new feature shows a pop-up message with information about the currently selected pivot table.

pivot table information

To find that new feature:

  • Click the arrow in the Pivot Table Info drop down
  • Then click the command, Info – Selected Pivot Table.

pivot table information command

Pivot Power Free Feature Fix

The feature fix in this version was for the other command on the Pivot Table Info drop down – List All Pivot Tables.

If there were data model (OLAP-based) pivot tables in the workbook, that List command didn’t work in the previous version. It showed an error message instead.

The macro is fixed now, so you can create a list of all the pivot tables in the active workbook, with a few details about them.

list all pivot tables

Minor Changes

Finally, in the background, I made a few minor changes to the PPF add-in:

  • All the links to my Contextures site were changed from http to https
  • The latest version number and date were added to the Contextures Info form
  • In the ReadMe text file, the links were changed to https and the new version number and date were added

Get the Pivot Power Free Add-in

To get the new version, go to the Excel Pivot Power Free add-in  (PPF) page on my Contextures site.

Or, check out the Pivot Power Premium (PPP) add-in, which is for pivot table power users only.

_______________________

Pivot Power Free Add-in Update

pivotpowerfreeupdate01a

Pivot Power Free Add-in Update

 

_______________________

Leave a Reply

Your email address will not be published. Required fields are marked *

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