| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Table Question
Hi
I run Win2K with Excel 2K I have a pivot table with a number of headings. Whenever I refresh the table the columns always adjust to autofit the headings. I would like to know is there any way that you can fix the column widths on a pivot table so that when you refresh the data they do not go back to the original with. Thanks, any help is much appreciated John |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Pivot Table Question
Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off. Click OK John Calder wrote: I run Win2K with Excel 2K I have a pivot table with a number of headings. Whenever I refresh the table the columns always adjust to autofit the headings. I would like to know is there any way that you can fix the column widths on a pivot table so that when you refresh the data they do not go back to the original with. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Pivot Table Question
Thanks a lot Debra, it works great !
John Calder "Debra Dalgleish" wrote: Right-click a cell in the pivot table, and choose Table Options Ensure that Preserve Formatting is turned on, and AutoFormat is turned off. Click OK John Calder wrote: I run Win2K with Excel 2K I have a pivot table with a number of headings. Whenever I refresh the table the columns always adjust to autofit the headings. I would like to know is there any way that you can fix the column widths on a pivot table so that when you refresh the data they do not go back to the original with. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Pivot Table Question
You're welcome! Thanks for letting me know that it worked for you.
John Calder wrote: Thanks a lot Debra, it works great ! John Calder "Debra Dalgleish" wrote: Right-click a cell in the pivot table, and choose Table Options Ensure that Preserve Formatting is turned on, and AutoFormat is turned off. Click OK John Calder wrote: I run Win2K with Excel 2K I have a pivot table with a number of headings. Whenever I refresh the table the columns always adjust to autofit the headings. I would like to know is there any way that you can fix the column widths on a pivot table so that when you refresh the data they do not go back to the original with. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Question | Excel Discussion (Misc queries) | |||
| Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
| Pivot Table Question | Excel Discussion (Misc queries) | |||
| Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
| pivot table question, sum fields? | Excel Worksheet Functions | |||
Linear Mode
