View the step-by-step solution to:


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

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question