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!! |
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 |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com