pivottables

[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

[Roger Govier]

Hi

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

--
Regards

Roger Govier


"lennert" <[email protected]> wrote in message
news:[email protected]...
> 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
>