Hi

I use WinXP with Excel 2000

I have a problem with a pivot table

The sheet that contains the raw data has 10 columns of data approx 1200 rows
deep

The 1st 6 columns of data is linked to another spreadsheet. The last four
columns are helper columns that I have added. All columns have unique header
names. This all works fine.

In my pivot table I use:-

2 of my headings in the €œPage€� area.

3 of my headings in the €œRow€� area

1 of my headings in the €œData€� area

This also works fine.


The problem occurs when I try to add another of my heading to the €œRow€� area.

I get the following error message:-

Microsoft Excel cannot make this change because there are too many row or
column items. Drag at least one row or column field off the Pivot Table, or
to the page position. Alternatively right click a field and then click Hide
or Hide Levels on the shortcut menu


I have other Pivot tables that have more headings that the one I am having
trouble with yet I dont get the same error message with these.

Even why I try creating a pivot table from scratch I get the same message if
I attempt to add the extra heading in the Row field.

Can anyone help?


Thanks

John