LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default Pivot table cell limit

Hi Peo

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

--
Regards

Roger Govier


"Peo Sjoblom" wrote in message
...
Yes there is a limit (256 characters I believe)



--
Regards,

Peo Sjoblom



"Momma-moomin" wrote in
message ...
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!!





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table text field limit of 255 Debb Excel Worksheet Functions 0 April 16th 07 08:08 PM
is there a limit to the # of rows in a pivot table? sheehanb Excel Discussion (Misc queries) 4 November 15th 06 12:07 AM
Pivot table row fields limit vs. number of rows in use for Excel 2 VP needs help Excel Discussion (Misc queries) 3 October 11th 06 08:11 PM
Excel limit that stops pivot table processing at column IV?? TooTall Excel Worksheet Functions 2 July 10th 06 02:19 PM
Pivot table limit Gilles Desjardins Excel Worksheet Functions 3 September 20th 05 02:14 AM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"