View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robin
 
Posts: n/a
Default Pivot table page fields add values previously deslected

I have pivot tables that I have selected only certain data in a page
field by dragging it to the detail, selecting only what I want, then
dragging it back to the page section. The problem is that when new
data shows up in the file, it automatically adds that data to the
field. This can cause erroneous information to be reported. Is there
any way to stop it from doing this?