Excel pivot table not updating
In Part 2 we look at how to format the Pivot Table in a more permanent way.
In Part 3 I present a quick VBA/macro solution to automatically update the Pivot Table format.
I have gone through several searches, including the SAS community and cannot find a solution to this problem.
Those custom lists take precedence when you’re sorting labels in a pivot table.
Fortunately, if things don’t sort correctly, you can fix the problem, by changing a pivot table setting.
Excel Pivot Tables are probably the single most powerful built-in feature of Excel.
If you analyse lots of data, my guess is that Pivot Tables are one of your favorite tools.
Joanne uses pivot tables and wants to choose a custom number format for her value field.