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?

Try this site:

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

Don
"gordo" wrote in message
...
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?

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

"Don" wrote:

Try this site:

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

Don
"gordo" wrote in message
...
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?

I'm glad I could help

Don

"gordo" wrote in message
...
Thank you, thank you, thank you. It worked.

"Don" wrote:

Try this site:

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

Don
"gordo" wrote in message
...
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?