Whenever you do a calculation in an Excel Pivot Table you may get an error value like a #DIV/0!

This looks ugly when you are presenting important information.  Luckily you can override this with a custom value or text.

To activate this you need to Right Click in any Value in your Excel Pivot Table and choose PivotTable Options and “Check” the box that says: For error values show

This activates the box and you can now enter any value or text that you want to show whenever your calculation has an error.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: We have an error in the pivot table calculation.

 

STEP 2: Right click on any value and Go to Pivot Table Options.

 

STEP 3: Check the Box: For Error Values Show

 

STEP 4: Enter any text or value

 

Now your error values are properly formatted!

Format Error Values

HELPFUL RESOURCE:

728x90

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

How To Insert a Pivot Table Slicer Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table.They are a new feature from Excel 2010 onward and Mac for Excel 2016 and a must for anyone wanting to wow their boss by adding interactivity i...
Sort Field List In a Pivot Table from A to Z Do you ever get in a situation where your Pivot Table Field List has over 20 fields and you spend heaps of time trying to locate one within the Field List?Well you can save time by sorting the Pivot Table Field List in alphabetical order!To do this you need to Right Click...
Free Pivot Table Webinar Hey there,I have been having a huge response to this highly acclaimed Pivot Table webinar and will continue to give these lessons in to the new year!  If a date is not suitable for you, you can always come back to the Registration link below on a future date.  Happy Pivot...
Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdue was the distinct or unique count.Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got the "total number of transac...