XL2000: Error Message: A Field in Your Source Data Has More Unique Items...

ID: Q226516

The information in this article applies to:

Microsoft Excel 2000

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:

http://officeupdate.microsoft.com/2000/downloadDetails/alerts.htm

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.

WHAT 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:

Q211517 XL2000: PivotTable Limits in Microsoft Excel 2000

Additional query words: OFF2000

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb