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.

We explain how to fix the issue when Excel is not auto-calculating formulas. Excel is an advanced tool when calculating formulas for statistics.