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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Insert Subtotals to a Pivot Table When you create a Pivot Table that has multiple fields in the Row Labels, Excel will automatically add a Subtotal to the top of the Group. What about if you want to change the Subtotals to show at the bottom of the Group or take the Subtotals out all together? Well you have...
Icon Sets In A Pivot Table An Icon Set is a Conditional Formatting icon/graphic that you can include in your cells or Pivot Tables. The icon will depend on the cell´s value so you can highlight key variances or trends.  There are a few icon sets that you can include, like: DIRECTIONAL (Change in valu...
Different Ways to Filter an Excel Slicer Excel Slicers are the best thing since sliced bread! They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that shows you what items have been filtered or selected in a Pivot Table. There are several ways that you can filter an Exce...
Add Custom Symbols With Your Numbers in Excel A cool feature within Excel is the ability to format a cell's value by pressing CTRL + 1 on any cell. This brings up the Format Cells dialogue box and under the Custom category you can customize the Type to whatever you like and even insert symbols! There are four formattin...