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

Why are deleted data items still showing up in the page field?

Why are deleted data items still showing up in the page field?

Problem

You deleted a data item from your data source and refreshed your pivot table. However, the data item still appears in your pivot table. In the example shown in Figure A.7, you see four regions, including Midwest, in the page field.

Figure A.7. The issue here is that the Midwest region does not exist any longer, and your data source does not have records tagged as Midwest. Your pivot table is holding on to this data item in its pivot cache.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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