pivottables

L

lennert

hi,

I created a pivot from a dataset. This was no problem at all. In a
later stadium I changed the recordset where the pivottable is based on.
For example i replaced all the records containing pete into mike in the
column <NAME>. When refreshing the pivot it now contains both mike and
pete. Pete is redundant, because i no longer exists. How do I get rid
of it?.

lennie
 
R

Roger Govier

Hi

Just drag the field out of the Pivot Table, then do a Refresh, then drag
it back again
 
Top