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.

When COULDN’T REFRESH DATA TYPES errors occur, the cells linked to live data are not refreshed because Excel cannot establish a connection with the external data source.

Learn how Excel’s Power Query can simplify data cleaning, automate tasks, and transform your workflow. Save time and reduce errors!