Copying a filtered pivot table

Hi everyone, I'll get right to it. I was given an extremely large Excel file that contains several worksheets with different pivot tables. To cut down on the size of the file, I'd like to filter the pivot tables by the largest fields (region) and create individual files for each region-specific table.My question is this: how do I copy only the information showing from a filtered table, leaving all the filtered out data behind? I'd like to keep the pivot table in tact outside of that and carry the formatting over to the new file.Thanks in advance! via /r/excel http://ift.tt/2rTmckv