Sorry komal, mis-read you.

In C 1 I have just put:-

quarter quarter quarter quarter

- and this does appear in the Pivot Table once refreshed.

Just play with it / update the cell / refresh the Pivot Table until you
reach the limit.



"komal" wrote:

I am sorry - Additional comments is one of the header fields like you have
"Qtr 1" etc. in the Pivot table. The content listed under Additional
Comments can be more than 3-5 lines as it is in most cases in my case.

The content displays fine in the actual spreadsheet, but when I run the
pivot report on it, it truncates the data.

I may have to ask folks to limit what they write and be very brief.

"trip_to_tokyo" wrote:

komal, I am not sure that I fully understand what you are saying.

Are you saying that the:-

Additional Comments

- in my Workbook (cell A 3) is considerably longer in your Workbook?

I think that's what you're saying.

If you say:-

"paragraph worth of
information"

- then I am not surpised that all of it is not appearing in the Pivot Table.

Would it not be possible for you to cut down the amount of information so
that it would appear in the Pivot Table properly? Why do you want so much
info?

Please hit Yes if my comments have helped.

Thanks.




"komal" wrote:

thank you!

The field is like memo field hence it has paragraph worth of
information...some of it is cutting off at the. Does Pivot tables have
character restrictions? Displays fine in the actual spreadsheet.

"trip_to_tokyo" wrote:

Hi komal.

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 36 towards the top of my home page.

It works OK for me. Check out the file. I hope that it helps in some way.

If my comments have helped please hit Yes.

Thanks.




"komal" wrote:

I have created pivot table from spreedsheet. One of the fields "additional
comments" doesn't display fully in the pivot report. I have tried increasing
column widths and row widths. I have also tried using Alt+enter as suggested
in some of other discussion forum.

Nothing is working so far. Any help appreciated.

Thank you!