Pivot Table question.
 

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

Pivot Table question.
 

Pivot Tables can use many more data points (hundreds of thousands) than the
number of Excel rows (65536). The trick is to link directly to the data
source. If your data source is an Excel SS, then no, the limitation here is
the sheet itself. Consider using Access as your data warehouse; dump
everything into a data table, save the file as an .mdb, and link your PT to
this source.


Regards,
Ryan---


--
RyGuy


"Sinner" wrote:

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