Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-using pivot table layout
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-using pivot table layout
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Layout | Excel Discussion (Misc queries) | |||
pivot table layout | Excel Discussion (Misc queries) | |||
Pivot table layout | Excel Discussion (Misc queries) | |||
Pivot Table Layout | Setting up and Configuration of Excel | |||
Pivot Table Layout Help | Excel Discussion (Misc queries) |