Destination reference is not valid in pivot table wizard

I was getting the following error in Excel 2010 today while trying to prepare a pivot table. “Data source reference is not valid”

When I copy and pasted the data into an entirely new worksheet it worked fine. The original spreadsheet was downloaded from the internet and it seems that excel throws up this error if you try to run the pivot table while the spreadsheet is stored in a temporary folder.

Hope this helps someone,

6 replies
  1. sameer
    sameer says:

    don’t know, what has gone wrong in my excel, I have not been able to create any pivot table in excel. I tried this at Office desktop as well as Laptop.

    If you get a chance could you please help me to fix this as soon as you can.

  2. Chris
    Chris says:

    Yep, I exported to a spreadsheet from a web-based report and got the error. As soon as I saved the file in another, non-temp location, it worked.

    You helped me and I appreciate it!


Trackbacks & Pingbacks

    Leave a Reply

    Want to join the discussion?
    Feel free to contribute!

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.