To alter the error display, select the For error values clearly show Examine box. From the box, type the worth that you want to display in lieu of errors. To display glitches as blank cells, delete any characters while in the box.Use the sphere area of the sphere Listing to add fields to your PivotTable, by checking the box close to area names to p