I've created a copy of a workbook but am using new data. In it I've got a pivot table. Let's say I had data 'a' through 'k' in the first workbook, and data 'l' through 'z' in the second (copied) workbook. My problem is that the pivot data continues to show 'a' through 'z' in the selection drop down list. I've done refreshes and verified the data source for the table. How do I get rid of the old data? Hope this makes sense.
