Pivot Table Format Options

I thought it would be fun to show you how to not display ugly valid errors, like DIV/0, when it’s there because there is a 0, but doesn’t need to show, because everyone knows that it’s zero. Also love to get it where the columns do not show ###### when we refresh. Pivots are fun but are more fun when we know these things.


PivotTableOptions

×

Comments are closed.