Error message:

Excel error message: Data source reference is not valid.

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



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


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


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="" 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"]