If you happen to be retrieving the data for your analysis by directly connecting Excel to a database, you might often encounter fields that have no spaces between their distinct words. Whilst this is indeed best practice when writing your SQL query (having to deal with spaces in SQL aliases can be a very annoying … Continue reading How Do I Quickly Insert Blank Space Between Upper Characters in a Pivot Field Title?
One of my recent articles elaborated on how to change the name of a Value Pivot Field under the assumption that the change had to be applied on all fields in all the pivot tables in the spreadsheet. It may be very often, however, that you only need to change the names of only 1 … Continue reading How do I quickly change the Pivot Field Name of Only Specific Fields?
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?