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