Expaning the Pivot Table Report Filter field

[srsims1000]

Afternoon,

I just was moved to Excel 2007 from 2003. I used to be able to expand the Pivot Table Report Filter field under the Pivot Table options. Once expanded, it created a separate worksheet for each value in the Report Filter field.

How can I do this in Excel 2007?

Thanks,
Steve

 

[srsims1000]

Nevermind...I found it. It's under the Options Tab, but listed as "Show Report Filter Pages" and not in the option selection.