Pivot table - multiple sources

B

BC...

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

steven1001

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