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.
3. Select the For Error Values, Show check box, as shown in Figure A, and leave the corresponding text box blank
4. Click OK to return to your PivotTable.

Adapt for Excel 2007
To access your PivotTable options in Excel 2007, go to the Options tab on the PivotTable Tools ribbon. In the PivotTable group, click the Options button. On the Layout & Format tab in the PivotTable Options dialog box, select the For Error Values, Show check box in the Format section. Click OK to verify the new setting.

Filed under: Microsoft Office Tutor