lmkapromotion.blogg.se - Pivot charts are not supported in mac excel 2013

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