Pivot table fields not updating
In response to those comments, I’ve created a new version of the sample file.
The latest sample file for changing pivot table fields has 3 variations on the "Change All Page Fields" code, and it also changes the "Multiple Item Selection" settings to match changed page fields (Excel 2007 and Excel 2010 only).
The three variations are: To see the code, and try the variations, you can download the sample file from the Contextures website.
The file will work in Excel 2007 or Excel 2010, if you enable macros.
PT0027 – Change All Page Fields – All Sheets or Active Sheet You can also download the other sample files, showing how to change a specific field, or all fields, in the workbook’s pivot tables.