Pivot Table drill down and 256 character limit

[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

 

[Dave Peterson]

Maybe you could use some sort of indicator/abbreviation. Then use =vlookup() to
return the longer string????

 

[Dave Peterson]

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.

 

[Doug_F]

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

 

[Dave Peterson]

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...