lock column widths in pivot tables

[troes04]

this is frustrating...every I make a selection in one of the Page Fields the column widths change and the pivot table is not viewable on a single page. I have tried checking the box next to 'Preserve Formatting' in the Table Options view, but that does not work.

suggestions appreciated, thanks all.

 

[Gerald Higgins]

Try UNchecking the box for Autoformat Table

 

[troes04]

<argh>

THANK YOU!