Hi,

I'm trying to analyse large amounts of data in Excel 97 and one of the
features I'm using is pivot tables.

Suppose I have four columns labelled a,b,c,d where in construction of
the pivot table I assign a to the rows, b to the columns, c to be the
data and d to be the page variable.

Now I have more data than can fit directly under the headers a,b,c,d
(only 60000 or so rows are available). What I thus want to do is put
more data to the side, in four new columns with exactly the same
meaning as in the original columns. Basically I just need a way of
adding more data to the pivot tables.

At the moment I've tried creating an excel file for each set of 60000
or so matching pieces of data but this could take me days and I have to
compile the pivot and set the formulae etc. each time.

I'd be extremely grateful if someone could help me with this problem
and tell me how I can add more data to my pivot table.


--
GJS
------------------------------------------------------------------------
GJS's Profile: http://www.excelforum.com/member.php...o&userid=37296
View this thread: http://www.excelforum.com/showthread...hreadid=570091