| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retain Column Width
When updating, or opening a pivot table the column widths keep
reverting back to a different width. I keep saving it in the new size and it keeps reverting back to a smaller size... this is becoming very frustrating. I have set settings to "save format on exit" .. what am i missing here, this is really driving me mad. With thanks Bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retain Column Width
go to pivot table options | uncheck the autoformat table | ok
On Oct 7, 2:41*pm, Box666 wrote: When updating, or opening a pivot table the column widths keep reverting back to a different width. I keep saving it in the new size and it keeps reverting back to a smaller size... this is becoming very frustrating. I have set settings to "save format on exit" .. what am i missing here, this is really driving me mad. With thanks Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't the copy/paste from PDF retain the row/column in excel? | Excel Discussion (Misc queries) | |||
| Move Column Retain Formula | Excel Discussion (Misc queries) | |||
| How do I retain leading zeros in a column of numbers when file op | Excel Discussion (Misc queries) | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Linear Mode
