Pivot table cell limit



Hi, can anyone help. My source worksheet has cells containing lots of text.
When I create a pivot table (in the same file), the data from the source
worksheet is truncated. Is there a cell limit on pivot table cells. If so
can I increase the capacity so I can show all the text in the pivoted table?

Roger Govier

Hi Peo

The limit has been increased from 255 in versions up to XL2003, to 32K
for XL2007.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question