Have a bunch of ugly #DIV/0! errors cluttering up your masterfully created PivotTable?

Here’s how to solve it:

  1. Go to PivotTable Tools -> Options
    1
  2. Go to Options Under the PivotTable section
    2
  3. Check the boxes for For error values show and click OK
    3

Before

Your data will now go from looking like this:

4

After

To this:

5

Much better!