| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workbook pivot table design function
I used Sheet1 as the data source to create a pivot table in a new worksheet
which I named Sheet PT. Is it possible to design the workbook so that I can delete the data in Sheet1 and then paste new data with more or less rows in Sheet1 and have the pivot table in Sheet PT update to reflect the new data that has been pasted into Sheet1 but the formating of the pivot table stays the same? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
| Pivot Table design problems (% of grand total etc) | Excel Discussion (Misc queries) | |||
| Pivot Table Design | Excel Worksheet Functions | |||
| Workbook Design | Excel Discussion (Misc queries) | |||
| How to copy pivot table workbook to new workbook? | New Users to Excel | |||
Threaded Mode
