Pivot table cell limit

G

Guest

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?
Thanks!!
 
R

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

Similar Threads

Is there a 255 character limit in pivot table cells? 1
Pivot table data source 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Workbook pivot table design function 6
TOO MANY CHARACTERS!!!! - PIVOT TABLE 5
Limitations with Pivot Tables 4
why do I lose cell format in a pivot table? 1
Pivot table for worksheet text fields? 2

Top