View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Ogilvy
 
Posts: n/a
Default Pivot Table refresh

Unless you want to write a macro, delete the pivot table and create a new
one.

--
Regards,
Tom Ogilvy

"neeses" wrote in message
...
Data has been removed from the worksheet that feeds the Pivot Table.

After
Refesh the deleted field name still appears in the drop down list. How can
the field name be removed?