ExcelBanter - Pivot Table Output - Limitation on words within the cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Output - Limitation on words within the cell (https://www.excelbanter.com/excel-discussion-misc-queries/234558-pivot-table-output-limitation-words-within-cell.html)

Rachel Young

Pivot Table Output - Limitation on words within the cell

Excel 2007:
Some of the data output from my pivot table includes cells which contain
text exceding 200 words. The end result is that some 'commentary', attached
to specific data, is 'chopped off' mid sentence.
How can I overcome this?

Thank you

All times are GMT +1. The time now is 03:33 PM.