Pivot table - multiple sources
 

I have a data source with ~75,000 records, which needs to be the source
for a series of pivot table reports. Is there a way, that I can break
the 75k records into 2 worksheet and have the tables on both sheets be
the source for my pivot tables?

I've see a very simplistic way to do this, within the help file, but it
doesn't provide the ability to see all of the data elements. Also,
these reports are distributed so linking to directly to an Access table
doesn't seem possible.

Any help would be greatly appreciated.


--
BC...
------------------------------------------------------------------------
BC...'s Profile: http://www.excelforum.com/member.php...o&userid=34318
View this thread: http://www.excelforum.com/showthread...hreadid=540825

Pivot table - multiple sources
 

Can't you use the pivot table on your data source, or you could put it into
Access and use the pivot table on the Access table?

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"BC..." wrote in message
...

I have a data source with ~75,000 records, which needs to be the source
for a series of pivot table reports. Is there a way, that I can break
the 75k records into 2 worksheet and have the tables on both sheets be
the source for my pivot tables?

I've see a very simplistic way to do this, within the help file, but it
doesn't provide the ability to see all of the data elements. Also,
these reports are distributed so linking to directly to an Access table
doesn't seem possible.

Any help would be greatly appreciated.


--
BC...
------------------------------------------------------------------------
BC...'s Profile:
http://www.excelforum.com/member.php...o&userid=34318
View this thread: http://www.excelforum.com/showthread...hreadid=540825

Pivot table - multiple sources
 

http://www.excelforum.com/showthread.php?t=538191 seems related


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=540825

Pivot table - multiple sources
 

oops .. pls ignore .. will still hit the 64k limit.
Can you export to a .CSV file and run the pivot table directly against
that as external data?


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=540825