Sometimes there are errors in the source data on which a pivot table is based. In most cases, I like to see the errors on the worksheet, so that problems are easy to spot. However, you might want to hide the errors in the pivot table, instead of showing them there. By default, error values [...]

A common problem in an Excel pivot table is that new items are added at the end of a drop down list. For example, in the following list, the Paper Clips item is at the end of the list, instead of appearing in alphabetical order. This problem can be solved by sorting the field as [...]