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.

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!