Hi,

Is it possible for a pivot table to e linked to two worksheets with
similar data in them.
Sheet length is 65536 till last cell. Is there a way to pick 65537th
record from next sheet in same pivot table? To be exact, first row of
sheet2 is header so from A2 of sheet2, the record count would be
65537th value.

Thanks