Error message:

Excel error message: Data source reference is not valid.

VBA error message:  Run-time error ‘1004’  Cannot open PivotTable source file “url []”

 

Problem:

Excel errors out when trying to create a pivot table.  Error message says Data source reference is not valid.

Cause:

File name has special character such as square bracket [.  Pivot tables cannot be created if filename has special characters.

Solution:

Remove all special characters from file name.  If file is opening from internet browser try saving the file instead of opening it.

Interested in learning new skills?