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.

[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]