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.

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and ...

Microsoft has announced a beta version of Excel that allows pivot tables to automatically update themselves when data is changed.

Why Can't I Insert a File in Microsoft Excel?. Along with the formulas, functions, calculations and data you enter into a Microsoft Excel worksheet, the program also accepts files from other ...