Pivot Table Setup

K

Keith

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?
 
J

Jon Peltier

Right click on the pivot table, choose Table Options.
Uncheck AutoFormat table, and check Preserve Formatting.

- Jon
 
Top