I have a similar problem with my pivot table.

Whenever I click on refresh data an error message displays that PivotTable
field name is not valid. I followed your website contexture on defining the
database word for word and it worked but now I try to refresh the data I get
the error message.

Please advise.

Best Regards,
EMoorhead
--
Estandardtime Realty


"Debra Dalgleish" wrote:

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

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


Seraphim wrote:
The dropdown lists in our PivotTables are not refreshing -- they still show
items that no longer exist in the original data.

How do I refresh the Pivot Table so these items disappear? Just clicking on
Refresh doesn't clear the dropdown lists.

Thanks.


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