In the source data, can you create a column to combine the colour, its
code and its reference number?
Then add that combined field to the pivot table, instead of all three
fields.
That may reduce the number of items sufficiently that it will allow you
to create the pivot table in Excel 2000.

The pivot table limits are lower in Excel 2000, and you can find more
information on the Microsoft web site:

http://support.microsoft.com/kb/211517/

John Calder wrote:
Hi

I have created a pivot on a spreadsheet on Excel 2000 running under Win 2000.

I require 6 columns of data in the pivot. The 1st 4 columns go in ok but
there are 2 other data columns that when I try to include them I get an error
message saying "Microsoft Excel cannot make this change because there are too
many row or column items"

I then took the file and put it on a computer running WinXP and Excel 2003.
It all works ok under these versions, so I am assuming that Excel 2000 cannot
handle the data in the same way that Excel 2003 does. So, I have 2 questions,
firstly why do I get the error message in Excel 2000 and secondly is there a
fix that I can get that will allow Excel 2000 to deal with this issue.

The data spread is as follows:

Col 1 = A one of entry (in this case a colour)
Col 2 = A one of entry (in this case a code number unique to the colour)
Col 3 = A one of entry (in this case a reference number unique to the colour)
Col 4 = A batch number that may be more than one relating to the colour
Col 5 = A date received that may be more than one entry related to batch
number
Col 6 = A age of paint number that is relateed to each batch number

Columns 1 - 4 go in fine, but the problem is with columns 5 & 6

Any help is much appreciated


John


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html