hi all,

When i expand out my pivot table the column headers squash up so you cant see the header text clearly. the text is on a couple of lines.

is there a way to lock the width so it does not adjust? i have un ticked autofit column widths on update.

thanks for any help