Excel 2010 PivotTable: My data source is a table on a worksheet that is in the same workbook as the PivotTable. When I add data and "Refresh," it works fine. However, when I click "Refresh All," I get a notice telling me that the data source is a different file - a file that was deleted a long time ago. I want to change the data source to the table that is in the workbook, but when I try to do this it does not work: I keep getting the message telling me that the data source is a different file.