Pivot Table changing copy changes original

Question

My boss has a pivot table on worksheets created with Excel 2003.  He would copy a worksheet (insert on a new worksheet) and edit the query to set new dates for a new quarter.  I recently moved him to Office 2010 and this functionality has changed.  Now, when he changes dates on the new query, the original pivot table dates change too.  The data source is an SQL 2000 database.

Does anyone know how to copy a pivot table and edit the query on the copy without changing the original?

Answer 1

Thanks for answering.  But either I don't understand how to "Select the PT" or this doesn't solve my problem.  I highlighted an area of the spreadsheet the included the PT.  Used CTRL-C and CTRL-V to paste it into a new worksheet (in the same workbook) and it does the same thing (changing the date in the query, changes the date for both spreadsheets).  I have not had any trouble with copying to a different workbook.

I have tried selecting by clicking the upper left corner (highlighting the entire worksheet) and lassoing the table (clicking one column outside the table and dragging the mouse to capture the entire table).  Is there something I am missing here?

My connection has a "name" (connection17), is there a way to copy and select a "new" connection (maybe one that is a copy of an existing connection)?

Answer 2

Don't copy the worksheet - the resultant PT shares the same cache. Select the PT and use Ctrl/C & paste it onto a blank worksheet, then work with that one.