Clearing drop down in Pivot Table

summergs · #1 09-01-2006, 04:51 PM

I have a pivot table that I want to reuse with different data. Basically I have my original data that I drop into a different worksheet, it gets pulled into the pivot table and I view it from there. I then delete my original data (from the worksheet not the pivot table) and drop in new data and refresh my pivot table. The new data is coming in fine but the drop downs for my pivot table are still populated with options from my original data. I'm surprised that the pivot table refresh button doesn't reset this data too but apparently it doesn't. Can someone please point me in the right direction to clearing and resetting the data in the drop down. No macros please as I can't use them for what I'm doing.
Thanks

Carim · #2 09-03-2006, 08:06 AM

Hi,

Take a look at Debra's solution

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

HTH
Cheers
Carim

summergs · #3 09-04-2006, 10:29 PM

Thanks for pointing me the link. However I tried the instructions there for manual removal, multiple times, and it did not work including removing all fields from the table and refreshing it. Here are the steps I tried

Manually Clear Old Items

To manually clear the old items from the list:

Drag the pivot field out of the pivot table.
On the Pivot toolbar, click the Refresh button
Drag the pivot field back to the pivot table

Any other ideas?

summergs · #4 09-04-2006, 10:30 PM

Thanks for pointing me the link. However I tried the instructions there for manual removal, multiple times, and it did not work including removing all fields from the table and refreshing it. Here are the steps I tried

Manually Clear Old Items

To manually clear the old items from the list:

Drag the pivot field out of the pivot table.
On the Pivot toolbar, click the Refresh button
Drag the pivot field back to the pivot table

Any other ideas?

Welcome to the Excel Forum

Forum Statistics