Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reuse of Pivot tables
Is there a way to reuse a pivot?
I get an updated spreadsheet every week and currently rebuild the pivot tables each time to produce regular reports. Is there a better way to do this - carry an existing pivot across to the new worksheet somehow? -- Mike Watkins |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reuse of Pivot tables
If the field names are the same, you could copy the pivot table into the
new workbook. Then, right-click on a cell in the pivot table, and choose PivotTable Wizard Click the Back button, and select the data range in the new workbook. watkincm wrote: Is there a way to reuse a pivot? I get an updated spreadsheet every week and currently rebuild the pivot tables each time to produce regular reports. Is there a better way to do this - carry an existing pivot across to the new worksheet somehow? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |