View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MLK MLK is offline
external usenet poster
 
Posts: 81
Default Pivot table filters

It's ok, I just figured out how.


"MLK" wrote:

I have a pivot table that currently displays hundreds of projects.

However, I need to have a way to ensure that users are only able to display
no more than one project at a time. Is there a way to do this.

The users can change the projects at any time, but I still only want to show
no more than one line at a time.

Thanks, Mary-Lou