Split Pivot Table to Separate Sheets

[healey21]

I am using Excel 2007 and am looking to use a Pivot table but I want to split the (Master Pivot) into separate sheets, by using the Report Filter Option.

I can't find it in 2007 is it still there? I can do it in 2003 as you have a Show Page option.

Help if you can

 

[Andrew Poulsom]

Select a cell in the pivot table. On the Ribbon Options tab click the dropdown arrow for Options then click Show Report Filter Pages.

 

[healey21]

Thank you Andrew,

I was finding it difficult to find.