Destination reference is not valid in pivot table wizard

Destination reference is not valid in pivot table wizard

Destination reference is not valid in pivot table wizard 257 120 Ralph Smith

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,

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

Contact us
close slider


[recaptcha]