 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007Limitations with Pivot Tables
I have created a Pivot Table from some data on an spreadsheet within the same workbook; one of the columns in my data is basically a string of text, these cells can contain 20 characters or 700 characters; when I create my pivot table and I pull this fields into my pivot table, for some reason the data gets truncated and it is displayed truncated. As an example one of the cells in my data has 379 characters, when pulling this cell into my Pivot Table it only shows 221, does any one know why? Is there any way that I can show all my data? By the way I’m using Office 2007. Cheers, Juan If you're adding the field to the row labels area, you should be able to see all the characters. Did you create the file in Excel 2007, or is it in compatibility mode? > I have created a Pivot Table from some data on an spreadsheet within the same > workbook; one of the columns in my data is basically a string of text, these [quoted text clipped - 8 lines] > > Juan  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Debra, thanks for your reply. I did add the field to the row labels area to the pivot table layout, and yes, the workbook was created on an earlier version of Excel (2003) and I'm using compativility mode, do you think that the compatibility mode is the one that is causing the problem? SignatureCheers, Juan > If you're adding the field to the row labels area, you should be able to > see all the characters. Did you create the file in Excel 2007, or is it [quoted text clipped - 12 lines] > > > > Juan Yes, I think so. Can you convert the file to Excel 2007 format? That should allow the higher limits. > Debra, thanks for your reply. I did add the field to the row labels area to > the pivot table layout, and yes, the workbook was created on an earlier > version of Excel (2003) and I'm using compativility mode, do you think that > the compatibility mode is the one that is causing the problem? SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Thank you Debra, save the file as a Excel Macro-Enabled Workbook and it works. You just save me from do an extensive copy and paste :) SignatureCheers, Juan > Yes, I think so. Can you convert the file to Excel 2007 format? That > should allow the higher limits. [quoted text clipped - 3 lines] > > version of Excel (2003) and I'm using compativility mode, do you think that > > the compatibility mode is the one that is causing the problem? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.