Contextures

Home > Pivot > Macros > Topics

Pivot Table Macro Topics on Contextures

Use Excel Pivot Table macros to automate pivot table tasks. Filter by date, value, top or bottom rankings, and more.

Author: Debra Dalgleish

Pivot Table Macros Tutorials

These popular tutorials show how to use different types of Excel Pivot Table macros.

Create Lists

1 --Excel Macro Lists All Pivot Table Fields -- Use this Excel macro to create a list of pivot table fields, with name, caption, orientation, position and formula

2 --Excel Macros for Pivot Table Pivot Cache - Lists, Info -- View pivot tables pivot cache information by using macros in this pivot table tutorial; see cacheindex, memory used, record count.

3 --Excel Macros List Pivot Table Styles and Custom Style Details -- Use these pivot table styles macros to list details for active workbook, or change default style. Download sample file for testing

list all the pivot fields in all pivot tables

Pivot Table Layout Macros

1 --How to Remove Excel Pivot Fields From Layout With Macros -- Use these macros to remove pivot fields from an Excel pivot table. Get the free workbook with macros and test data

2 --How to Remove Excel Pivot Fields with Macros for Data Model -- Use these macros to remove pivot fields from Excel pivot tables, Normal or Data Model (OLAP). Get free workbook with macros, test data

3 --Excel Pivot Table Macros Block Features in Data Model Pivot -- Use macros to restrict or enable pivot table features, for pivot tables based on the Excel Data Model. Block selections, dragging, more

4 --Excel Pivot Item Macros -- Change Pivot Items in an Excel Pivot Table with these macros. Get the free workbook with the macro code

5 --Pivot Table Value Heading Macros Remove Sum Of Count Of -- Use these Pivot Table Value heading macros to remove Sum Of in pivot field headings, For Normal, OLAP or both types of pivot table

More Pivot Table Macros

1 --How to Fix Data for Pivot Table with Excel Unpivot Macro -- Excel unpivot macro fixes pivot table source data that has amounts in multiple columns instead of single column. Download sample file with code

2 --Save Time with Excel Pivot Table Printing Tips and Macros -- Print Excel pivot tables with macro examples in this pivot table tutorial. Print a separate pivot table or pivot chart for each page item

3 --Pivot Table Option Macros -- Use these macros to create a list of pivot table option settings for a selected pivot table.

Pivot Table Macro Videos

Here's one of my top Excel pivot table macro videos, and many my Excel pivot table tutorial pages include a video too.

Use this macro to create a list of all the pivot tables in the active workbook, with details on the source data, and possible conflicts with other pivot tables, or missing headings. This video shows how the macro helps with trouble shooting, and there are written details on the Macros to List All Pivot Tables page.

Excel Pivot Table Macros - Sample Files

Here are the download links for a couple of my latest Excel pivot table macro sample workbooks, and most of the Excel tutorial pages include a sample file too.

More Workbooks: For even more pivot table sample files, go to the Excel Sample Files page, and scroll down to the Pivot Table section.

   
PT0049

Slicer Shows Pivot Table Value Groups -- Click a Slicer, to quickly show and hide groups of values in a pivot table. Function slicer changes summary function and heading.
Excel File: slicervaluegroupshow.zip (has macros)

   
PT0046 Budget Report Selector -- Enter Forecast and Actual data for a budget, see the summary in a pivot table. Click the Slicer to change values in the Pivot Table report - choose the forecast, actual, YTD, Variance or Variance Percent.
Excel File: budgetselectreport.zip (has macros)

 

About Debra

 

Last updated: December 29, 2022 2:09 PM