re-using pivot table layout

  • Thread starter Thread starter kmcclell
  • Start date Start date
K

kmcclell

I just created my first pivot table! Each month I get a new excel
spreadsheet with data that I want to manipulate in this same pivot table
layout. All columns and rows are the same. How can I save my pivot table's
layout and re-use it each month with the new data? Thanks
 
Clear the contents of the old month's data.

Paste the new data where the old data was.

Right click within the pivot table and select "Refresh Data".

Happy days, you are done!

Tom
 
Back
Top