Problem with Pivot Table Drop-Down Menus

M

Mac

Comments or help, please!

I use pivot tables extensively, but I am having several problems. Can
anyone explain this behavior?

PROBLEM #1:
1) I have some data that includes country names, dates, and expenses
from which I have created a pivot table. I can go to the data range and
delete one of the countries from the middle of the group of data. No
problems.
2) Then I refresh the pivot table. No problems.
3) The country that I deleted won't show up in the pivot table (as I
expect), but if I click on the drop down menu for Country, it will still
show the country name that I deleted. In my opinion, the drop down menu
should not show the country because the underlying data has been deleted.


PROBLEM #2:
1) I can go to the Data range and change the name of the Country,
such as CHILE to CHILLY. No problems.
2) Then I refresh the pivot table. No problems.
3) The spelling of CHILLY will now properly show up in this pivot
table, but when I use the drop down menu for Country, the menu will now show
CHILE and CHILLY. In my opinion, the menu should only show CHILLY in the
drop down menu.



How can I refresh the drop down menus in a pivot table??

TIA

=Mac=
 
M

Mac

Debra,

You are a Princess... that's better than an MVP!

Thanks for your help.

=Mac=
 
K

Ken Wright

Aahhh, but our Princess MVP Debra benefits from both titles :)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



Mac said:
Debra,

You are a Princess... that's better than an MVP!

Thanks for your help.

=Mac=
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Refresh Not Updating Drop Down List 1
Link Drop Down with Pivot Table 2
How to clear data in pivot table? 4
Pivot Table Chart Drop Down Box 6
Calculated item - problem 3
Pivot table filter list - listing irrelevant subcategorys 1
Consolidate two Data Sets for Making a Report 1
Pivot Tables- SQL Alias' & Field Lists 1

Top