Pivot table - 256 character limitation?

[Tony]

Hi Group,

I am using Excel 2000.
I am running a pivot table on data (exported from an
Access 2000 database) that groups projects by area. I
have come across a problem where if text stored in cells
is longer than 256 characters then it is truncated within
the pivot table. Very strange. No matter what I try I
cannot get it to display the full text (which is project
descrption summary).

Is this a bug, is there a workaround?

Regards

Tony

 

[keepITcool]

afaik there's no limit in the pivottable that would
block text strings longer than 256.

i can import date directly from a range or linked
access database without problems.


if you exported the data to a workbook and based you pivot on
a query on that closed workbook you could have some problems.
see:
http://support.microsoft.com/default.aspx?kbid=257819



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Tony]

Thanks for your reply.
The exported data is not connected in any way to the
database and is completely independant.
Cell E10 in Data worksheet contains 638 characters but
when I perform the pivot table only 255 characters have
been brought across.
Any other ideas?

Thanks

 

[keepITcool]

ouch.. ouch.. ouch!

i originally did my testing manually and hasty.
the string that i typed in manually was 248...

i did some real tests... and hmmm...
it will truncate text to a maximum of 255 chars.

mea culpa.
I should have known.. Excel does have a 16bit brain.

keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >