Pivot Table Field's Item Listbox

[Guest]

I have a pivot table whose source is a worksheet. When I change the data in
the worksheet and refresh the table, the items listed for fields still
contain items that are no longer in the worksheet. How do I update the list?

 

[Don]

Try this site:

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

Don

 

[Guest]

Thank you, thank you, thank you. It worked.

Try this site:

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

Don

 

[Don]

I'm glad I could help

Don

Thank you, thank you, thank you. It worked.