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.

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical ...

How to Recover a Microsoft Excel File That Is Not in a Recognizable Format. If Microsoft Excel fails to recognize a file in the XLSX or XLS format, the data contained in the file could be corrupted.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.