View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default Pivot Tables - delete rows from Master List

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