Quote Originally Posted by Paul_Hossler View Post
What I've done in the past was to use a macro to write each page field's (e.g. Department) filtered pivot table data to a separate workbook as just their data.
Actually I'd be interested in that- do you have the code for it?