How Do I Quickly Change a Pivot Value Field Name with VBA?

There are a couple of ways you could approach it: Option 1: Get rid of the default "sum of", "count of" that gets automatically inserted when you're building a pivot table Do comment out the irrelevant lines, though! For example, if you do not have count fields or average fields, make sure that those are … Continue reading How Do I Quickly Change a Pivot Value Field Name with VBA?

How Do I Quickly Change a Pivot Field Number Formatting with VBA?

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?

How do I re-filter only selected Pivot Tables in my workbook?

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?