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

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

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

Pivot Tables - delete rows from Master List
 

Generally here is how Pivot tables work. They read in information from some
kind of souce such as a worksheet into something called the pivot cache.
Everything the Pivot table does is based on the cache an not the underlying
source data. There are a couple of things which could explain the behaviour
you see. On the Pivot Table toolbar select PivotTable - Table Options and
adjust the Data Options at the bottom as necessary.
--
HTH...

Jim Thomlinson


"mathel" wrote:

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