Eliminate error values in your PivotTable (2003/2007/2010)

If your PivotTable’s source data contains errors, you’ll notice those errors pop up in your PivotTable too. Here’s how you can replace error values with blank cells in your PivotTable:

1. Click anywhere within your PivotTable to view the PivotTable toolbar (or choose View | Toolbars | PivotTable from the menu bar).
2. Click the PivotTable button on the PivotTable toolbar and choose Table Options from the resulting menu. Excel displays the PivotTable Options dialog box. (In 2007, click on the PivotTable button on the PivotTable Tools ribbon, then choose Options.)
3. Select the For Error Values, Show check box, and leave the corresponding text box blank.
4. Click OK to return to your PivotTable.