Excel Pivot Tables are probably the single most powerful built-in feature of Excel.
The top row in blue shows what you type into Excel to get the custom number format, and the bottom row in pink shows examples of positive values, negative values and zero values.
One way to clear the old items is to do the steps manually: If you’re using Excel 2002 or Excel 2003, there isn’t a Retain Items setting in the Options dialog box, but you can prevent old pivot items, with a bit of programming.
Things weren’t so easy, in earlier versions of Excel, so you’ll need a longer piece of code to remove the old items from the pivot table.
Laurence, who emailed me about the problem, is still using Excel 2000.
I’m sure he’s not the only one, so here’s the issue that he encountered, and the simple solution.