2 Replies Latest reply: Jul 12, 2016 8:32 AM by Mark O'Donovan RSS

    Nprinting 16 - Pivot tables on Multiple Worksheets

    Mark O'Donovan

      Hi all,


      I'm trying to create 1 pivot table on separate worksheets, 1 per region.

      The source data is in 1 worksheet.


      I have added a page to the sheet that contains the pivot table.


      Now I would like to filter the pivot table by region.


      Is there a simple way to do this ?


      Would have been nice if the Excel 'Show Filter Report Pages...' worked.


      When I try to put the data in the same worksheet as the pivot table I get a 'Reference is not valid' error.