I have a large file (22,000 records). There are a number of pivot tables on
different sheets in the file. When I go to one of the tables I created
earlier, it seems that the Pivot Table loses it's identity. That is, when I
click in this table I don't get an indication that it's still a Pivot Table
(blue lines don't appear in table). Sometimes I do a copy of some of the data
in the original working Pivot Table and paste it on the same sheet to create
a chart. Can this be a problem?