Pivot table - 256 character limitation?
 

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

Pivot table - 256 character limitation?
 

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" wrote:

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

Pivot table - 256 character limitation?
 

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



-----Original Message-----
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" wrote:

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

.

Pivot table - 256 character limitation?
 

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


"Tony" wrote:

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