PivotTable
 

I have data where I using with pivot table. I have more than 1000 data in
sheet1 and pivot table in sheet2 when I delete some data from sheet1 it
should also delete from sheet2. but its not delete from sheet2.

Pls help me.

****al Shah

PivotTable
 

On May 17, 9:39 pm, ****al shah
wrote:
I have data where I using with pivot table. I have more than 1000 data in
sheet1 and pivot table in sheet2 when I delete some data from sheet1 it
should also delete from sheet2. but it’s not delete from sheet2.

Pls help me.

****al Shah

the following site might help:
http://www.cpearson.com/excel/pivots.htm

PivotTable
 

There are instructions here for clearing old items from a pivot table:

http://www.contextures.com/xlPivot04.html

****al shah wrote:
I have data where I using with pivot table. I have more than 1000 data in
sheet1 and pivot table in sheet2 when I delete some data from sheet1 it
should also delete from sheet2. but its not delete from sheet2.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html