Pivot Table Setup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Right click on the pivot table, choose Table Options.
Uncheck AutoFormat table, and check Preserve Formatting.

- Jon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table - undo of a macro 1
Pivot Table refresh 3
Dynamic data ranges in pivot tables 3
re-using pivot table layout 1
Pivot table wizards 2
Adding to an existing Pivot Table 7
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Pivot table data layout - columns to rows 1

Back
Top