Microsoft KB Archive/226516

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

Article ID: 226516

Article Last Modified on 12/2/2005

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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:

http://www.microsoft.com/downloads/details.aspx?FamilyID=8FBEE1D3-C5BB-4A36-A2F7-DC63DE2A818C

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

Additional query words: OFF2000

Keywords: kbdownload kbprb KB226516

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.