Excel PivotTable error handling

Excel PivotTable error handling

18 November 2017

Obviously, we don't want our PivotTables littered with #DIV/0! and #NULL! errors if we're presenting them in a report. That would just create unnecessary questions and we're busy enough.

Thankfully Excel PivotTable error handling is easy to control via the PivotTable Options. This article shows you how.

As a bonus, this article also discusses what to display when the prior period was zero. Specifically, is the percentage change from nothing to something equal to 100%?