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