Is there a way I could change the number formatting of all my pivot fields without having to spend forever on it?! Sure! The VBA snippet below has some of the most common number formats, which you can directly re-use in your code! PS. Do make sure to un-comment the formats that you do not … Continue reading How Do I Quickly Change a Pivot Field Number Formatting with VBA?
I had an interesting case a couple of years back, which resulted in quite a bit of head-scratching on my part. I was working as a reporting analyst and one of my key deliverables was to produce a monthly analysis of the hours that our consultants had logged on different projects. The analysis was to … Continue reading How do I re-filter only selected Pivot Tables in my workbook?
• You’ve got to change a bunch of value fields that have all been automatically added as “Count” instead of “Sum”? • You need to "average" rather than "sum"? • You’ve suddenly realized that you should be using “Count Numbers” instead of “Count” in a dozen of your spreadsheet pivot tables? Cheer up! You can … Continue reading How Do I Quickly Change a Pivot Table Summary Function with VBA?