Hi,

I'm using the reverse pivot technique suggested by Debra Dalgleish to
create a list dataset from which I can make a pivot table. The only
problem is that because there are so many years going across, whenever I
try to do this the computer tells me it was only able to do an
incomplete list because the full list exceeds 65,000 lines.

Apart from having to break the dataset down into smaller datasets, is
there some way that I could hook up the original dataset to an Access
database and do the reverse pivot technique successfully that way in
order to get a complete dataset list for the pivot table?

There are about 100 years going across.

Any suggestions would be much appreciated. Many thanks.

Matthew Kramer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!