| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Setup
Is there a way to save the layout of a Pivot tabe? I have several tables that
get updated every week, and every week I have to go and resize all the columns. Is there a way that I can update the data in my table without it changing the layout of the table? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Setup
Right click on the pivot table, choose Table Options.
Uncheck AutoFormat table, and check Preserve Formatting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Keith" wrote in message ... Is there a way to save the layout of a Pivot tabe? I have several tables that get updated every week, and every week I have to go and resize all the columns. Is there a way that I can update the data in my table without it changing the layout of the table? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Setup
Hi Jon,
That worked a treat. Thanks very much. Have a good Christmas and New Year Keith "Jon Peltier" wrote: Right click on the pivot table, choose Table Options. Uncheck AutoFormat table, and check Preserve Formatting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Keith" wrote in message ... Is there a way to save the layout of a Pivot tabe? I have several tables that get updated every week, and every week I have to go and resize all the columns. Is there a way that I can update the data in my table without it changing the layout of the table? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Filename reference in Spreadsheet XML issue | Excel Discussion (Misc queries) | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Linear Mode
