If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.

Avoid costly Excel errors! Learn the top 7 mistakes users make and how to fix them for better productivity and smarter workflows. MS Excel is ...