| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do updates work when creating a pivot table based on another?
I've never quite got how this works. If I create a pivot table based on
another, does it matter which one I base it on? Also If I update the main data source do I have to go to each pivot table and update each one manually - or if one is updated do all the others based on it update too? Thanks Diane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do updates work when creating a pivot table based on another?
Does nobody know the answer to this or is it a silly question?
"DianeG" wrote: I've never quite got how this works. If I create a pivot table based on another, does it matter which one I base it on? Also If I update the main data source do I have to go to each pivot table and update each one manually - or if one is updated do all the others based on it update too? Thanks Diane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating pivot from a horizontal table | Excel Worksheet Functions | |||
| Creating a table based on rank | Excel Worksheet Functions | |||
| Creating a league table based on results | Excel Worksheet Functions | |||
| Creating a Pivot Table | Charts and Charting in Excel | |||
| Pivot Table - Updates | Excel Discussion (Misc queries) | |||
Linear Mode
