XL2000: Error Message: A Field in Your Source Data Has More Unique Items... (226516)
The information in this article applies to:
This article was previously published under Q226516 ERROR MESSAGE
When you try to create a PivotTable, you receive the following error message:
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.
NOTE: Microsoft Office 2000 has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to enable this functionality for this and other error messages in Microsoft Office 2000, please download the Microsoft Office 2000 Customizable Alerts file from the Microsoft Office Update Web site at the following address:
NOTE: If you reached this article by clicking the Web Info button in an error message, you already have Customizable Alerts enabled.
CAUSE
You may receive this error message if a field in your PivotTable contains too many items.
THINGS TO TRY
If you have fields that contain too many unique items, try using page fields or server page fields in your PivotTable.
For additional information please see the following article in the Microsoft Knowledge Base: 211517
XL2000: PivotTable Limits in Microsoft Excel 2000
| Modification Type: | Minor | Last Reviewed: | 12/2/2005 |
|---|
| Keywords: | kbdownload kbprb KB226516 |
|---|
|