Hi!

I have a pivot table that I am using for tracking safety data - however, when it's being used to view the outstanding amounts, it defaults to opening a new worksheet in the current workbook. Then the user saves and closes it, and eventually there are a hundred worksheets in the workbook that should just be two.

How do I get it to open a new workbook when selecting the row values?