Sometimes, you just have to rename an item in a pivot table, even when you pulled it straight from a data source. The line item gets renamed in the pivot table, and Excel will remember that name indefinitely now. Except, you might not remember what it was called before…
One quick way to fix this is use the “Clear All” button for the Pivot Table. This clears everything, including those renamed items.
This can get a bit complicated with some reports, however. Let’s say that you’re using grouping, or you’ve filtered and sorted a hunk of stuff in the report, or you have a bunch of conditional formatting set, and using the “Clear All” function for the Pivot Table would result in a lot of rework.
I have a workaround. There might be a better way, and if so, I’d like to hear it, but this way, at least, will keep your groupings and formats.
It’s pretty simple – just go into your query and find the column in question:
and then “add” something to the name, like this:
Now, when you pull all your project names into your Pivot Table, they will look like this:
Project Name AHello
Ugly, but you’ll notice that the part before “hello” actually shows you the original names.
Now go back into your query and remove that + ‘hello’ and refresh.
Bam! Your original names are back in.
Not a very exciting little piece of info, but helpful to someone, somewhere, someday I hope!