In this case, you can use the Name Manager to identify the values referenced and make the necessary modifications to resolve the issue. The data source refers to a named range that contains invalid references – Another possible reason why this error occurs is when the range is defined but it references to invalid values.In this case, you can resolve the issue by defining the rage before attempting to create the PivotTable. If you’re trying to create a Pivot table with a range that wasn’t defined, you’ll be by the same error message. The pivot table data refers to a non-existent range – A range that is not defined properly can also be causing this particular error.If this scenario is applicable, you can resolve the issue by saving the. In this case, the file will be opened from a temporary folder, which doesn’t have the same permissions as a regular folder. Excel file is not saved on the local drive – You might be seeing this particular error message if you attempt to create a Pivot Table from an Excel file opened directly from a website or an email attachment.

In this case, the issue can be resolved by editing the file name and removing the square brackets. One popular reason why you might be seeing this particular error is if the excel file name contains ‘’. Excel file name contains square brackets – There are a set of forbidden characters that are not supported by Pivot tables.

Invalid reference error in excel