Inside Microsoft Excel

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

Inside Microsoft Excel

by Kara Hiltz

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.[…]

Subscribe to Inside Microsoft Excel

(get full access to archives and more)