Pivot Table drill down and 256 character limit

  • Thread starter Thread starter Doug_F
  • Start date Start date
D

Doug_F

When you double click on a value in a pivot table, a new worksheet tab is
opened that displays the raw data used for that value. It appears that text
fields in this new sheet are limited to 256 characters.

Is there a way to have the entire text value show up?

Thanks for the assist.

Doug

This is Excel 2003, SP3
 
Maybe you could use some sort of indicator/abbreviation. Then use =vlookup() to
return the longer string????
 
Ps. I bet if you look closely at the pivottable field, you'll find that the
long string field has already been truncated to 255 (256??) characters.
 
Dave,

Sorry for the long delay responding...been eating a lot of turkey lately...

I can't abbreviate the field; it's a free text data field and we need all of
the information for it to be meaningful - you never know if a critical bit of
data is at the beginning of the string or the last 3 words.

The field itself is imported from another source and the raw data in the
data table (not the pivot table) is all there.

Sounds like a 256 character limit and we be screwed...darn.

Thank you for your reply.

Doug
 
Maybe you could use the truncated string and an =index(match()) to return the
longer string:

=index(sheet1!a:a,match(x99&"*",sheet1!a:a,0))

This would assume that the first 256 characters are unique...
 
Back
Top