Pivot Tables formatting

[sunrise06]

I have broken out my pivot table by a filtered field so now I have numerous tabs. I want to be able to set Rows to repeat at top for all of these individual tabs but that option appears to be grayed out. Thoughts on how to accomplish this?

 

[wist]

can you clarify further? maybe provide some screens/spreadsheet

 

[sunrise06]

To clarify. This appears to be not just be a problem using pivot tables, it is any spreadsheet in which you select multiple tabs. Open a spreadsheet and select two tabs. Go to Print Titles, Page Setup Sheet tab, the Rows to repeat at top, you will see it is grayed out.

I am looking to see if there is another way to accomplish this task.

Thanks