How to remove non-exist values in pull-down list in pivot table

[Terence C]

Dear all,

I have a pivot table which gets data from a table in SQL server table.
However, some rows are deleted permanently in the SQL table but if the field
is put in the row or column fields, the deleted value is still available for
selecting in the pull-down list.

For example, I have a field which holds staff names but some staff members
are not working in the company anymore and the related records are deleted in
the SQL table. But in the pivot table, such staff names still appears in the
pull-down list even the pivot table is refreshed.

So how to remove the items in the pull-down list also? Can anyone advise?
Thanks in advance!!

 

[Pecoflyer]

Dear all,

I have a pivot table which gets data from a table in SQL server table.
However, some rows are deleted permanently in the SQL table but if the
field
is put in the row or column fields, the deleted value is still
available for
selecting in the pull-down list.

For example, I have a field which holds staff names but some staff
members
are not working in the company anymore and the related records are
deleted in
the SQL table. But in the pivot table, such staff names still appears
in the
pull-down list even the pivot table is refreshed.

So how to remove the items in the pull-down list also? Can anyone
advise?
Thanks in advance!!

Hi,
'this site' (http://www.contextures.com/xlPivot04.html) provides
answers to this question