Hide #DIV/0! From Excel Pivot Table
Conditional formatting #DIV/0! within Excel is easy enough, but that doesn’t work in Pivot Tables.
Luckily, there’s an option within Pivot Table options that allows you to configure what appears when an error value is raised.
Simply check For error values show: and, in my case, leave the entry blank. Or set it to 0. Whatever works best for you. Divide by zero be gone with you.
Hope this helps!