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.
Recently Asked Questions
- In 1542 , Delas Casa wrote a letter called " of the Island of Hispaniola". Who was the letter addressed to ?.
- Can you please help with a reference for the following question? Describe why the competencies of the past are not compatible with the competencies of the
- Research current articles using the Internet search of websites related to hospitality law. You may also use other Internet or databases to choose a specific