Hi

Right click on the PTTable Optionsuncheck Autoformat

--
Regards
Roger Govier



"Bendinblues" wrote in message
...
How do I keep the formats of the pivot tables from changing when the data
is
refreshed? column widths change and I have to keep going back and
selecting
word wrap.