+ Reply to Thread
Results 1 to 2 of 2

Pivot Table error message

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    6

    Pivot Table error message

    Trying to create a pivot table, but I keep getting this error message...

    "A field in your source data has more unique items than can be used in a PVT report. Excel may not be able to create the report, or may create the report without the data from this field."

    My data has 48759 different ID numbers, is there a way around this error?
    -Thanks

  2. #2
    Registered User
    Join Date
    09-23-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Pivot Table error message

    Found a way around the error by concatenating my data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table error message but can't find the offending pivot table
    By dcoates in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-22-2013, 08:45 AM
  2. Pivot Table Error MEssage
    By Mike in forum Excel General
    Replies: 1
    Last Post: 07-26-2006, 08:32 AM
  3. [SOLVED] Error Message for Pivot Table
    By vicky0512 in forum Excel General
    Replies: 0
    Last Post: 06-26-2006, 03:00 PM
  4. Pivot Table Error message
    By Rich Mogy in forum Excel General
    Replies: 1
    Last Post: 02-27-2006, 08:28 PM
  5. Error message when using Pivot Table
    By Grrffin in forum Excel General
    Replies: 2
    Last Post: 11-17-2005, 05:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1