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

Pivot tables 2
Pivot Table - 3
Value filter missing in pivot table 3
date filter in a pivot table 1
Data display incomplete after creating Pivot Table 6
Pivot tables - memory issues - please help 2
pivot table in Excel 2007 & 2000 (backward compatibility problem) 3
Question on the occupied field of the pivot table in excel spreadsheet 0

Top