I'm having some trouble preserving the formatting of my pivot tables when I change the layout. I followed the Micrsoft troublshooting steps that I pasted below but it still doesn't retain all the formatting. Selecting that box does keep the column width intact but it still loses the text wrapping every time I change the layout. I'm only changing 1 item in the report filter and it loses the wrapping.

MS troublshooting help:

Check the preserve setting Click PivotTable on the PivotTable toolbar, click Table Options, and make sure the Preserve formatting check box is selected.

Any help you could provide would be great!

Thanks!