After refreshing data, the existing pivot table will expand columns with (both text and numbers) results to the new data width. I then have to reset the column width back to my requirement.
How can I set column width in a pivot table so the widths do not change when new data is introduced. Also, can it be set so the data results justify, wrap and expand row height to show the whole result in the pivot cell?
All suggestion gratefully received