View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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 ***