software

I can set up pivot tables just fine, but when the data source changes and I
refresh the pivot table I keep seeing old, deleted records in my pivot report
drop down lists. I've checked the new data source and verified that the data
no longer exists, but the selection is still showing in the pivot table. For
example: my data source may have a field labeled quot;Itemsquot;. In the initial data
set, for Items there would be Apples, Oranges and Bananas. If I change the
data set and delete all Banana items, leaving just Apples and Oranges, I
still see Bananas listed as a seletion item in the refreshed pivot table. If
I select Bananas in the pivot table I do not see any data, however I want to
remove Bananas from the list all together. How can I refresh the pivot table
without showing the old data?

Weird. I just looked up the same problem this morning myself. I found the
answer on Debra's site.

www.contextures.com/xlPivot04.html

quot;PRTexquot; wrote:

gt; I can set up pivot tables just fine, but when the data source changes and I
gt; refresh the pivot table I keep seeing old, deleted records in my pivot report
gt; drop down lists. I've checked the new data source and verified that the data
gt; no longer exists, but the selection is still showing in the pivot table. For
gt; example: my data source may have a field labeled quot;Itemsquot;. In the initial data
gt; set, for Items there would be Apples, Oranges and Bananas. If I change the
gt; data set and delete all Banana items, leaving just Apples and Oranges, I
gt; still see Bananas listed as a seletion item in the refreshed pivot table. If
gt; I select Bananas in the pivot table I do not see any data, however I want to
gt; remove Bananas from the list all together. How can I refresh the pivot table
gt; without showing the old data?

Thanks a million, JC!! The manual method Debra suggested didn't work but the
automated method did!

quot;Jonathan Cooperquot; wrote:

gt; Weird. I just looked up the same problem this morning myself. I found the
gt; answer on Debra's site.
gt;
gt; www.contextures.com/xlPivot04.html
gt;
gt; quot;PRTexquot; wrote:
gt;
gt; gt; I can set up pivot tables just fine, but when the data source changes and I
gt; gt; refresh the pivot table I keep seeing old, deleted records in my pivot report
gt; gt; drop down lists. I've checked the new data source and verified that the data
gt; gt; no longer exists, but the selection is still showing in the pivot table. For
gt; gt; example: my data source may have a field labeled quot;Itemsquot;. In the initial data
gt; gt; set, for Items there would be Apples, Oranges and Bananas. If I change the
gt; gt; data set and delete all Banana items, leaving just Apples and Oranges, I
gt; gt; still see Bananas listed as a seletion item in the refreshed pivot table. If
gt; gt; I select Bananas in the pivot table I do not see any data, however I want to
gt; gt; remove Bananas from the list all together. How can I refresh the pivot table
gt; gt; without showing the old data?

I still cannot get this to work! how did you get the Automated to work.

quot;PRTexquot; wrote:

gt; Thanks a million, JC!! The manual method Debra suggested didn't work but the
gt; automated method did!
gt;
gt; quot;Jonathan Cooperquot; wrote:
gt;
gt; gt; Weird. I just looked up the same problem this morning myself. I found the
gt; gt; answer on Debra's site.
gt; gt;
gt; gt; www.contextures.com/xlPivot04.html
gt; gt;
gt; gt; quot;PRTexquot; wrote:
gt; gt;
gt; gt; gt; I can set up pivot tables just fine, but when the data source changes and I
gt; gt; gt; refresh the pivot table I keep seeing old, deleted records in my pivot report
gt; gt; gt; drop down lists. I've checked the new data source and verified that the data
gt; gt; gt; no longer exists, but the selection is still showing in the pivot table. For
gt; gt; gt; example: my data source may have a field labeled quot;Itemsquot;. In the initial data
gt; gt; gt; set, for Items there would be Apples, Oranges and Bananas. If I change the
gt; gt; gt; data set and delete all Banana items, leaving just Apples and Oranges, I
gt; gt; gt; still see Bananas listed as a seletion item in the refreshed pivot table. If
gt; gt; gt; I select Bananas in the pivot table I do not see any data, however I want to
gt; gt; gt; remove Bananas from the list all together. How can I refresh the pivot table
gt; gt; gt; without showing the old data?