Limitations with Pivot Tables

[Guest]

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

 

[Debra Dalgleish]

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?

 

[Guest]

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?

 

[Debra Dalgleish]

Yes, I think so. Can you convert the file to Excel 2007 format? That
should allow the higher limits.

 

[Guest]

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