To alter the error display, select the For mistake values demonstrate Check out box. In the box, kind the worth that you might want to display instead of glitches. To display glitches as blank cells, delete any figures while in the box.To refresh details on file open up Pick to possess Excel refresh PivotTable info every time the file is opened.Mer