Created pivot (Pivot1) from a table (Table1), but the pivot left out a record that appears on the table. Copied the table to a new worksheet, pasting it as values only, then converted it to a table (Table2) and created a pivot (Pivot2) from that. The original record was now in the new Pivtot2; however, two other records are now missing from Pivot2. How can I fix this? Thanks