View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Pivot Table Cleanup

Have you tried right-clicking on the pivot table and selecting Refresh?

"tommcbrny" wrote:

Hello,

The pull down fields in my pivot tables have several values that are no
longer valid for one reason or the other. They no longer appear in the
source data of the table, in other words. Is there a way to clean up these
pull downs to eliminate the unecessary data?

Thanks,
Tom