| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables - delete rows from Master List
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
