Have a bunch of ugly #DIV/0! errors cluttering up your masterfully created PivotTable?
Here’s how to solve it:
- Go to PivotTable Tools -> Options
- Go to Options Under the PivotTable section
- Check the boxes for For error values show and click OK
Before
Your data will now go from looking like this:
After
To this:
Much better!