View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mathel mathel is offline
external usenet poster
 
Posts: 64
Default 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