If you want to prevent accidental changes to a pivot table’s layout, you can hide the pivot table buttons and labels. There are a few benefits from doing that. Continue reading “Hide Excel Pivot Table Buttons and Labels”
Author: Debra
How to Show Rank in an Excel Pivot Table
A pivot table makes it easy to summarize a large amount of data, to see how your business is doing. But big numbers are hard to analyze at a quick glance. To make things clearer, you can show rank in an Excel pivot table, as well as the large numbers.
Quickly Remove a Pivot Table Field in Excel
Here’s a quick tip that shows how to remove a pivot table field in Excel. A very short video shows the steps, and there are written steps too, below the video.
Continue reading “Quickly Remove a Pivot Table Field in Excel”
Connect Slicer to Multiple Pivot Tables
For a quick way to filter an Excel Pivot Table, you can insert a Slicer, for one or more of the pivot table fields. You can also connect Slicer to multiple pivot tables, if all the pivot tables use the same pivot cache.
Find and Fix Pivot Table Source Data
After you create a pivot table, you might add or change records in the source data. When you refresh the pivot table later, sometimes the new data doesn’t show up. Here’s how to find and fix the pivot table source data, so the correct data appears.
Quickly Count Duplicates with Excel Pivot Table
Excel is a great tool for working with a list of data, and calculating sums and counts. Use functions like COUNTIF and COUNTIFS, to get counts based on one or more criteria. But don’t forget about pivot tables, when you need a quick count or sum. With a few clicks, a pivot table will quickly show how many of each item are in a list.
Continue reading “Quickly Count Duplicates with Excel Pivot Table”
Macro to Remove Pivot Table Calculated Fields
If you record a macro while you remove pivot table calculated fields, then try to run that macro later, you’ll get an error message. To solve that problem, use my macro to remove pivot table calculated fields. The code is shown below, and there’s also a sample file with the macro. To see all the steps, watch the short video.
Continue reading “Macro to Remove Pivot Table Calculated Fields”
Change All Pivot Charts with Single Cell Filter
If you have several pivot charts on an Excel dashboard, and space is limited, here’s a way to change all pivot charts with a single filter cell. When you select a different date from the drop down in that cell, all the pivot charts are automatically updated. There are NO macros for this technique, just Slicers, that are stored on a different sheet.
Continue reading “Change All Pivot Charts with Single Cell Filter”
Easy Trick to Move Pivot Fields
Here’s an easy trick to move pivot table fields to a different location in a pivot table, just by typing. See the steps in the short video, and there are written steps below the video, if you prefer those. Continue reading “Easy Trick to Move Pivot Fields”
Excel Macro Lists All Pivot Tables and Pivot Fields
If you have a big Excel file, with lots of pivot tables, you might want to document everything that’s in the workbook. Maybe you inherited the workbook, and you’re not sure what’s in it. Or perhaps it’s a file that you only use occasionally, and it’s hard to remember what it contains. To get the details quickly, use the code shown below. This Excel macro lists all pivot tables and pivot fields in the active workbook.
Continue reading “Excel Macro Lists All Pivot Tables and Pivot Fields”