Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove old labels from refreshed pivot tables? | Excel Discussion (Misc queries) | |||
Getpivotdata references have stopped loading pivot-refreshed value | Excel Worksheet Functions | |||
Pivot Table to be refreshed whenever the web query is being refres | Excel Discussion (Misc queries) | |||
Is there a way to compare a pivot table refreshed data to old one | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |