| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot table - Charachter limitation
Is it a display problem or the strings are truncated. At what length?
-- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" wrote in message ... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Output - Limitation on words within the cell | Excel Discussion (Misc queries) | |||
| Pivot Table Styles limitation? | Excel Discussion (Misc queries) | |||
| Excel pivot table limitation when having Access | Excel Discussion (Misc queries) | |||
| pivot table limitation | Excel Discussion (Misc queries) | |||
| Pivot table - 256 character limitation? | Excel Programming | |||
Hybrid Mode
