Pinterest Pixel

Format Error Values in a Pivot Table

Whenever you do a calculation in an Excel Pivot Table you may get an error value like... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

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.

Format Error Values in a Pivot Table | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

 

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

Format Error Values in a Pivot Table

 

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

Format Error Values in a Pivot Table

 

STEP 3: Check the Box: For Error Values Show

Format Error Values in a Pivot Table

 

STEP 4: Enter any text or value

Format Error Values in a Pivot Table

 

Now your error values are properly formatted!

Format Error Values in a Pivot Table

 

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

See also  Excel Pivot Table Field List - Activate, move, resize & layout
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!