Hi,

A little more detail might help what is the structure of your pivot table,
what is the error message you are getting, what do you long fields contain
and how long are them? What version of Excel are you using.

And maybe, why do you want a monster text field in a pivot table?

--
Thanks,
Shane Devenshire


"Carrie_Loos via OfficeKB.com" wrote:

Hi -

I have been conducting interviews and some of the responses are long. I have
tried to put them in a pivot table but there seems to be a field size limit.
(By the Way, MS Access is not available). Is there a way I can either extend
the field size which would be my preference or can you suggest a different
way? Using the lookups as a formula are overwhelming the size of my file.

Thanks
Carrie

--
Message posted via http://www.officekb.com