re-using pivot table layout

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
 
T

TomPl

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
 
Top