To alter the mistake display, decide on the For mistake values clearly show Verify box. From the box, sort the value that you would like to display instead of problems. To display errors as blank cells, delete any characters in the box.To refresh details on file open up Pick to have Excel refresh PivotTable details each time the file is opened.For