Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column width of Pivot Table data goes back to default when data refreshed
I have generated a pivot table and then applied one of the auto table
formats (Table 8 I believe in Excel 2003). The width of the columns is too wide therefore I manually decrease the width of the columns of the data field. Unfortunately, every time that I refresh the pivot table the column widths return to the default "wide" width. Other formatting that I apply seem to remain (such as filling in cells with a color). This occurs even if I do not apply any of the auto table formats format to the pivot table. Is there a way to keep the column widths from returning to the default width after I have adjusted them? Thanks, Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table format changes when data is refreshed | Excel Discussion (Misc queries) | |||
Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
Locking Column Width when changing Data in a Pivot Table | 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) |