Pivot Table drill down and 256 character limit

Pivot Table drill down and 256 character limit

Post by RG91Z19 » Fri, 27 Nov 2009 00:22:09


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
 
 
 

Pivot Table drill down and 256 character limit

Post by Dave Peter » Fri, 27 Nov 2009 02:13:33

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



--

Dave Peterson

 
 
 

Pivot Table drill down and 256 character limit

Post by Dave Peter » Fri, 27 Nov 2009 02:14:17

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 Peterson
 
 
 

Pivot Table drill down and 256 character limit

Post by RG91Z19 » Fri, 04 Dec 2009 03:01:01

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
 
 
 

Pivot Table drill down and 256 character limit

Post by Dave Peter » Fri, 04 Dec 2009 05:12:34

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





--

Dave Peterson