Pivot Table row data

[David_UK]

Hi guys,

I;ve just created a pivot table and in the first one, I was able to place 7 items in the row data section,

In the Column I have 2 items and in data I have 1 item once run the table is fine and is perfect for what i need, however,

I noticed an error in the source data so I deleted the whole thing and re-ran the source data from my database, and litterally did the same thing again, I even did a screen print so I could get the exact same layout, then when I ran the table it said that there are too many rows and excel cannot show all the data, try hiding rows etc...

Why did it work the first time and not the second? can anyone help please?

David.

 

[colbymack]

David,
Is this the message you are receiving?
"A field in your source data has more unique items than can be used in a PivotTable. Microsoft Excel may not be able to create the PivotTable or may create the PivotTable without the data from this field."

If so, refer to the following webaddress:
http://support.microsoft.com/default.aspx?scid=kb;en-us;211517#XSLTH4135121123120121120120

If not, please post the exact error message.

 

[David_UK]

The message reads,

Microsoft cannot make this change because there are too many row or column items. Drag at least on row or column 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.

Thanks,

David.

 

[colbymack]

Refer to the posting titled "Too Many Rows/ Columns in Pivot Chart" posted by Duffymt. Hopefully that will shed some light on the subject.

Basically it is telling you that the combinations of things are resulting in more than 8000 occurrences of one of your column or row values (not that a particular value is being repeated, but that there are more than 8000 unique values.

HTH