Formats of pivot tables changes when data is refreshed
 

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.

Formats of pivot tables changes when data is refreshed
 

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.

Formats of pivot tables changes when data is refreshed
 

I still need to go back to each pivot table and select the column then select
word wrap. The Autoformat solved the issue with the column widths that keep
changing when the data gets refreshed but not the column wrap problem.

"Roger Govier" wrote:

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.