• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

When I refresh my pivot table, my data disappears

When I refresh my pivot table, my data disappears

Problem

After you refresh your pivot table, the field you placed into the data area disappears, effectively removing the data in your pivot table.

Solution

You will run into this behavior when you change the name of the field you placed into the data area. For example, if you created a pivot table and placed a field called Revenue into the data area, your pivot table will show revenue numbers in the data area. If you were to go to your source data and change the Revenue column heading name to “Dollars” and then refresh your pivot table, the numbers in the data area would disappear. This is because when you refreshed your pivot table, it took a new snapshot of your data source and determined that there is no longer a field called “Revenue”—and it cannot calculate a field that is not there.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint