Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
256 character limit in pivot tables
I am building a string of unique codes that can exceed 256 characters. When
it does and I view the data in a pivot table, it truncates to 256. Is there any simple way do deal with this? I thought Office 2007 increased this limitation. I am using this string to identify unique configurations, each defined by the string of order codes on the invoice. I am then using the pivot table to count the number of occurances of each unique configuration. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
256 character limit in pivot tables
Hi jd
If you have opened an existing XL2003 workbook in XL2007, it will open in compatibility mode and you will be restricted to 256 columns and 65536 rows. Save the file as .xlsx file, close it and then re-open it and you will have the 2007 worksheet dimensions available to you. -- Regards Roger Govier "jd" wrote in message ... I am building a string of unique codes that can exceed 256 characters. When it does and I view the data in a pivot table, it truncates to 256. Is there any simple way do deal with this? I thought Office 2007 increased this limitation. I am using this string to identify unique configurations, each defined by the string of order codes on the invoice. I am then using the pivot table to count the number of occurances of each unique configuration. __________ Information from ESET Smart Security, version of virus signature database 4527 (20091020) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4527 (20091020) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a 255 character limit in pivot table cells? | Excel Worksheet Functions | |||
Character limit when printing | Excel Discussion (Misc queries) | |||
Is there a limit number of characters for cells in pivot Tables? | Excel Discussion (Misc queries) | |||
255 Character Limit | Excel Discussion (Misc queries) | |||
Character limit in an Excel Row | Excel Worksheet Functions |