Data missing in field in pivot table

G

Gilly

Using office 2003. I have created a pivot table from data in excel with many
columns. The data in the comments column cuts off after 254 characters (with
spaces), and some of the comments contains 500+ characters.

Kind regards
 
D

Dave Peterson

Yep. That's the way pivottables work.

Maybe you could add a column to the raw data that is shorter based on the longer
column. Then you won't have to worry where the field gets truncated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Power Pivot. Yikes. 0
Pivot Table Counting Text Data 0
Pivot Table - Row Label Combination 0
Additional columns for Pivot table 0
Creating a Search using a combo box and then creating a report. 4

Top