+ Reply to Thread
Results 1 to 5 of 5

Pivot table - Charachter limitation

  1. #1
    Darin Kramer
    Guest

    Pivot table - Charachter limitation

    Howdie...

    My Pivot table doesnt display all the data that it is meant to!!
    It is effectively running out of charachters
    (The source contains a large number of charachters in each individual
    cell) Within the source its fine, but within the pivot table drops
    charachters from the end.

    Alternative solutions to overcome this problem....? Your thoughts are
    most welcome!!!

    Thanks

    D

    *** Sent via Developersdex http://www.developersdex.com ***

  2. #2
    Tom Ogilvy
    Guest

    Re: Pivot table - Charachter limitation

    Is it a display problem or the strings are truncated. At what length?

    --
    Regards,
    Tom Ogilvy

    "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
    news:%23J77zHLqFHA.4088@TK2MSFTNGP15.phx.gbl...
    > Howdie...
    >
    > My Pivot table doesnt display all the data that it is meant to!!
    > It is effectively running out of charachters
    > (The source contains a large number of charachters in each individual
    > cell) Within the source its fine, but within the pivot table drops
    > charachters from the end.
    >
    > Alternative solutions to overcome this problem....? Your thoughts are
    > most welcome!!!
    >
    > Thanks
    >
    > D
    >
    > *** Sent via Developersdex http://www.developersdex.com ***




  3. #3
    Darin Kramer
    Guest

    Re: Pivot table - Charachter limitation


    The strings are truncated. Length 255
    (I thought of merging cells, or the like, but it gets too complicated.)


    *** Sent via Developersdex http://www.developersdex.com ***

  4. #4
    Tom Ogilvy
    Guest

    Re: Pivot table - Charachter limitation

    I think you are stuck with that limitation.

    Pivot tables are designed for summarizing numerical data, so it is certainly
    conceivable that the pivotcache was not designed to hold more than 255
    characters of data for any single "cell".

    --
    Regards,
    Tom Ogilvy

    "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
    news:e4vhiPLqFHA.904@TK2MSFTNGP09.phx.gbl...
    >
    > The strings are truncated. Length 255
    > (I thought of merging cells, or the like, but it gets too complicated.)
    >
    >
    > *** Sent via Developersdex http://www.developersdex.com ***




  5. #5
    Dave Peterson
    Guest

    Re: Pivot table - Charachter limitation

    Maybe you could assign a unique key for each of those long strings.

    Then use =vlookup() to return the long string based on that unique key.

    (This may not be much of a solution if you really pivot those tables.)

    Darin Kramer wrote:
    >
    > Howdie...
    >
    > My Pivot table doesnt display all the data that it is meant to!!
    > It is effectively running out of charachters
    > (The source contains a large number of charachters in each individual
    > cell) Within the source its fine, but within the pivot table drops
    > charachters from the end.
    >
    > Alternative solutions to overcome this problem....? Your thoughts are
    > most welcome!!!
    >
    > Thanks
    >
    > D
    >
    > *** Sent via Developersdex http://www.developersdex.com ***


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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