Hide Error In Pivot Table In Excel

Pivot table comes to rescue when we want some quick aggregation in a short notice.We could quickly summarize our data and put it in a presentable tabular format.However we get some frequent error in the pivot table and of course we would not like to show those errors in the presentation.

Its a simple task to hide error in a pivot table with the help of couple of steps.

Let’s see how we can hide error in a pivot table.

When we calculate a field in a pivot table, we get some error which does not look good and presentable.

We will see how to hide or oppress such errors in a pivot table in excel.


Step 1

Select anywhere in the pivot table and go to Pivot Table Options.


Step 2

Tick the checkbox which says “For error values show” and enter the value which you want to be displayed in place of an error in the pivot table in the box next to it.

I have given the values as “NA”, you could give any value that you want to show instead of an error in the pivot table.


The error has been replaced with “NA” as shown below


Hope this helped.

Share The Knowledge

Random Posts

  • Assign Random Characters to Cells In Excel

    In this pose we will see how could we generate random characters in excel and assign random characters to cells […]

    Share The Knowledge
  • Change Name Range In Excel

    Name range is of the most useful features in excel.The challenge in our day to day excel activities are that […]

    Share The Knowledge
  • Enable/Disable Macro In Excel

    Let’s see how we   can Enable or Disable macros in an excel workbook. Step 1 Click on File at the […]

    Share The Knowledge
  • Arabic Function In Excel

    Let’s see how to use Arabic function in excel. Arabic function was introduced in excel 2013. Arabic function is used […]

    Share The Knowledge

Leave a Reply