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,