View Single Post
  #1   Report Post  
Eva
 
Posts: n/a
Default no show all function in dropdown list in Pivot Table

Dear Sir,

I'm using excel 2000 professional version. When I create new pivot table,
everthing is fine but once I want to look at the specific item, I have no
"show all" function in the dropdown list of item field. So that I have to
unmark all items, instead of only unmark the "show all". How can I have "show
all" function in this case?

thanks