Depending upon the hierarchy of your fields, columns can be nested within columns that are higher in position.To refresh data on file open Choose to possess Excel refresh PivotTable details every time the file is opened.If the field listing is not any longer noticeable, Visit the PivotTable tab, swipe left and choose Area Record to display the sect… Read More