Check out that each one quantities are stored as figures Should the results will not be what you envisioned, the column might include numbers stored as textual content in lieu of as figures.To refresh details on file open Find to get Excel refresh PivotTable details every time the file is opened.Merge or unmerge cells for outer row and column goods