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