| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Column Width when changing Data in a Pivot Table
I have a Pivot Table, with 2 items in Page, 2 items in Column, and 17 items
in Data. I principally change the values in Page, and when I do the column width always changes, either it increases or decreases - how can I permanently lock this so that I dont have to adjust this manually every time. Many thanks in advance DP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking Column Width when changing Data in a Pivot Table
Hi
Right click on PTTableOptionsuntick Autoformat tabletick Preserve Formatting -- Regards Roger Govier "pepperds" wrote in message ... I have a Pivot Table, with 2 items in Page, 2 items in Column, and 17 items in Data. I principally change the values in Page, and when I do the column width always changes, either it increases or decreases - how can I permanently lock this so that I dont have to adjust this manually every time. Many thanks in advance DP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Changing the data of a Pivot Table | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
