| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to remove non-exist values in pull-down list in pivot table
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove non-exist values in pull-down list in pivot table
Terence C;351290 Wrote: 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 -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98308 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Clear old Pivot Table Fields that no longer exist | Excel Discussion (Misc queries) | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| how to remove old selection values in the pivot table | Excel Discussion (Misc queries) | |||
| How to eliminate xero values from pivot table and list top 10 only | Excel Worksheet Functions | |||
| How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
Linear Mode
