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=

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html

Mac wrote:
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=




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra,

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

Thanks for your help.

=Mac=


"Debra Dalgleish" wrote in message
...
There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html

Mac wrote:
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=




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote in message
...
Debra,

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

Thanks for your help.

=Mac=


"Debra Dalgleish" wrote in message
...
There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html

Mac wrote:
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=




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004

You're welcome!

Mac wrote:
Debra,

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

Thanks for your help.

=Mac=


"Debra Dalgleish" wrote in message
...

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html

Mac wrote:

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=




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html