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,
Check to also see if the workbook is protected. Just go to unprotect and try again.
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!
Perfect!!! You helped me too. Thanks!
I encountered this same problem. Thank you very much for your tip. It is a real time saver.
Click the sheet you want the table on click on a cell. You can add multiple tables on the same sheet.
Typically replies within a day
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.