LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel Pivot Tables

What is the maximum number of unique items a Pivot Table can display? I'm
using MS Excel 2000 and in trying to summarize data that have 14,140 unique
values, I get the error message "a field in your source data has more unique
items than can be used in a pivot table. Microsoft Excel may not be able to
creat the Pivot Table, or may create the Pivot Table without data from this
field."
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Pivot Tables SueC[_2_] Excel Discussion (Misc queries) 1 October 31st 07 03:09 PM
new to using pivot tables and excel Wendy Elizabeth New Users to Excel 6 September 21st 07 12:06 AM
Excel and Pivot Tables Michelle Excel Discussion (Misc queries) 5 August 24th 07 03:44 PM
Excel Pivot tables Pivot Tables Excel Discussion (Misc queries) 6 July 26th 07 03:32 PM
Excel Pivot Tables Brent_in_Oregon Excel Discussion (Misc queries) 0 December 9th 05 11:16 PM


All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"