K
KevinF
In the pivot table, it has filtering features which allow
you to display a subset of the total information with in
the pivot table. My problem is that the filter drop down
box displays information which no longer is contained in
the database of information. Can I get rid of these
filter options without recreating the pivot table? I've
refreshed, doesn't work.
Example: The lefthand column of information in the pivot
table is Project Code; A, B, C. I've recently deleted
project code C from the database of information, but yet
it shows as an option in the column drop down box of the
pivot table. Ugg. I refresh, and it is still there.
Thanks for the help.
Kevin
you to display a subset of the total information with in
the pivot table. My problem is that the filter drop down
box displays information which no longer is contained in
the database of information. Can I get rid of these
filter options without recreating the pivot table? I've
refreshed, doesn't work.
Example: The lefthand column of information in the pivot
table is Project Code; A, B, C. I've recently deleted
project code C from the database of information, but yet
it shows as an option in the column drop down box of the
pivot table. Ugg. I refresh, and it is still there.
Thanks for the help.
Kevin