Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data display incomplete after creating Pivot Table
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data display incomplete after creating Pivot Table
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data display incomplete after creating Pivot Table
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data display incomplete after creating Pivot Table
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data display incomplete after creating Pivot Table
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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data display incomplete after creating Pivot Table
Hi komal, I have just played around again with the file that I put up on my
website. I have put this into cell A 3:- 123456789 123456789 123456789 123456789 123456789 If you refresh the Pivot Table it does show all of the above. I think you just need to play with this to see how many characters it will take but it looks as though you can get quite a few in to me and this may help you out. "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! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data display incomplete after creating Pivot Table
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table doesn't display all data | Excel Discussion (Misc queries) | |||
Why do I get invalid data source when creating a pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table: Display data | Setting up and Configuration of Excel | |||
Creating a Pivot Table with data in more than one worksheet | Excel Worksheet Functions | |||
I am having problems creating pivot table of data | Charts and Charting in Excel |