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:

Click anywhere within your PivotTable to view the PivotTable toolbar (or choose View | Toolbars | PivotTable from the menu bar).
Click the PivotTable button on the [...]

Filed under: Microsoft Office Tutor | No Comments »