Save the Excel file to the computer or local drive.Renaming the Excel file to remove square brackets Remove the brackets by renaming the file to “ Correcting the Source Reference not Valid Error in a Pivot Table.xlsx”.įigure 3. Note the square brackets in the word Correcting. Error in creating a pivot tableĪs shown, the file name is “ the Source Reference not Valid Error in a Pivot Table.xlsx”.
When we try to insert a PivotTable, an error is displayed and the pivot table is not created.įigure 2. If it contains any square brackets, rename the file and remove the brackets.īelow is an example of a simple table with range B2:E6. The data source refers to a named range with invalid referenceĬhecklist to Correct the Source Reference Not Valid Error.The pivot table data source refers to a non-existent range.File comes from the email or on the web and is not saved in the local drive.Excel file name contains the characters “ ” or square brackets.
Most probably, the reason for the error is one or more of the following: “Data source reference is not valid” error message in Excel When working with pivot tables, we sometimes encounter the error “Data source reference is not valid”.įigure 1. Correcting the Source Reference not Valid Error in a Pivot Table
