I have created a pivot table in excel 2007 and used one of the Pivot Table Styles for formatting. I would now like to copy this worksheet to a new spreadsheet but just bring over the values and the formatting, not the "Pivot Table".

How do I bring over the formatting? I've tried paste special and format painter but neither will bring over the formatting within the pivot table itself. It will only bring over formatting that is outside the pivot itself.

Thank you for any help you can give me.