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. |
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 |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com