Hide Error Values in a PivotTable

If you've worked with PivotTables a lot, you know it's a great tool for analysis. You can slice and dice the data, move the elements around to show different views and even make some calculations in the table itself (i.e., calculated columns). And it's all contained in the tabular format of the table; all neat and tidy for you. But what if there are errors? I'm not talking about calculation errors in the data; that you'll have to figure out. Just talking about the visual aspect of seeing those error messages like when Excel is not sure of the data. An example is when you create a calculated field and have some division equation.  If the denominator is nothing, then you'd get a divide by zero error with would show #DIV/0 in the data field.  If you'd prefer not to show these error messages and keep the table looking "clean", that can be done with some minor tweaking.  See the video below to learn how.


🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~