Pivot Magic

Pivot Magic

Pivot MagicThis is a very short post but I did learn something new about pivot tables. I don’t know if this feature has always been present or just got implemented in Excel 2013, but it is a very, very nifty feature. And in the words of my boss, “It is big.”

I learned that you can send someone just the pivot table without all of the data details that formed the pivot. I believe that as long as you set up the criteria to show everything, the person who receives the table can pretty much arrange the pivot however he likes without the underlying original data. This feature shrinks down the size of the table and enables you to send the file.

That is amazing.

Has this always been available?

Similar Posts

Using Data Model to Hold More Data
|

Using Data Model to Hold More Data

Do you ever run into a situation where you try to pull in data into your Excel via Get Data in the Data tab but there is more data than rows available in your file? I used to use Access for those situations, but lately it looks like Microsoft, maybe since last summer, has revamped…

Two topics: hurricane weather and the need to double check your Excel results.
|

Two topics: hurricane weather and the need to double check your Excel results.

This post is going to be very short because I have a headache, probably from lack of sleep over worry about this storm. We’re supposed to have tremendous amount of flooding over the weekend – between 15 -20 inches.  The weather is coming in via hurricane and it is supposed to stall in our area for…

Working with Messy Data Again
|

Working with Messy Data Again

Ahhh, I’m working with another one of those downloads where the data do not lie in nice columns. I want to be able to compare data between two different downloads to make sure that the data is migrated correctly from one software to another. I would like to make Excel do most of the comparison…

Limits on How Long Your Macro Can Be

There is a Limit to How Long a Macro Can Be

This is going to be a quickie post because I did not do anything exciting. Well, I did go to a conference but I didn’t get enough materials to create an interesting post – or a post as interesting as I can make it. So this will be a very short post. A couple of…

Designing Methodology
| |

Designing Methodology

I appear to be going through a stretch where whatever I do, I’m not happy with: either it looks or works awful or just doesn’t plain work or it just takes too long. Any idea I have just doesn’t come like the way I imagine it. Anyway I still have to push on. I’m currently…