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