Forum Discussion

Patricia_Jones5's avatar
Patricia_Jones5
Copper Contributor
Jan 05, 2023

Pivot table Update

Good morning,

I have a pivot table on my excel sheet. I have updated the information there including pivot fields (dates changed). When I press refressh, the whole table disappears

Excel
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Jan 05, 2023
    You may want to check your data source via PivotTable Analyze tab menu | Change Data Source menu. Also, if the field names changed in the source data, then the pivot was refreshed, the pivot will remove the old fields - new fields would have to be re-added.

Share