Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
pivot reports are a view if you will, on the underlying master table.
so yes, you are correct. however, double clicking one of the pivots extracts the raw data which isn't dependent on the master table "mathel" wrote in message ... I have a workbook with 3 worksheets. One is a Master list, and the other 2 are Pivot Tables (called Under 10k & Over 10k). Once I have done the Pivot report, I no longer need the data in the rows from the Master list. However, I find that if I delete the rows, the Pivot Table is reverting to 1 line with no data. Am I assuming correctly that no data should be eliminated from the Master List in order that the Pivot Tables filter properly? -- Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create 1 master list from a combination of rows and columns | Excel Discussion (Misc queries) | |||
Pivot tables - edit pivot table and updating master data | Excel Programming | |||
How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) | |||
updating data in rows from master list | Excel Programming | |||
updating data in rows from master list | Excel Programming |