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?

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?

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?