Fix: "Data Source Reference Is Not Valid" Error In Excel
Some users have reported the “Data source reference is not valid” error when creating Pivot tables on Microsoft Excel. When you run into this issue, Excel
Source Reference Is Not Data Source Reference Not Valid Source Reference Excel File Pivotchart Excel
Source: technewstoday.com