Pivot Table question.

  • Thread starter Thread starter Sinner
  • Start date Start date
S

Sinner

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 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---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

modified pivot table using a macro 2
macro 4
Playing back a Pivot Table macros 2
Query then pivot table 6
Pivot Table Question 2
Unable to Group in Pivot Table 1
Pasting Pivot data 1
Expand and collapse 2

Back
Top