Eliminate error values in your PivotTable (2000/2002/2003)

by Kara Soos

Application:

Microsoft Excel 2000/2002/2003

Operating System:

Microsoft Windows

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