I had this problem a few years back. I think the problem was with my installation of excel, try doing something like a spell check in a drawing or creating a design table, to see if excell works correctly with SolidWorks.
If it is excel that is causing the problem it might be how it is installed on your computer. When you go to the microsoft site and download microsoft office it gives you an option to start using office as you are downloading it, this causes problems when you want to use excel with SolidWorks.
If this is your problem you should download the installation files for microsoft office to your hard drive and then install it from there.
Try to do a repair on excel, or if that does not work uninstall excel and and then reinstall excel again, just make sure you do not select the option to start using excel as it is still being installed.
Thanks for the suggestions, I didn't think that it could be an excel issue.
I will give it a try.
It's working perfect on SW2010 with excel 2010 on Windows 7 64bit
Browse to the excel file location and point to the file
Just add only the range without sheet name
Hope this works!
I am having the exact same issue with SW 2015 SP5.
I also have a mobile workstation that I use for a backup and to travel with if I need to go to the customers site and I have SW 2016 SP1 installed on it to do some testing before I upgrade my daily workstation and I am using the exact same syntax on both A2:A200 for one of my list contained in the Excel file and I get the same error you are getting with SW 2015 but it works fine with SW 2016.
The SW 2016 Property Tab Builder did change the syntax when I re-opened the template to the same shown in the Tab Builder like this Sheet Name(A2:A200) but when I setup the link I only typed A2:A200 and it worked the Tab Builder changed it to the syntax described. I tried both syntax in SW 2015 Property Tab Builder but still get the same error.
I followed some of the suggestions on here and to verify Excel was working with SolidWorks I created a table for a part and this is working without any issues so I don't believe it has anything to do with the install for Excel.