Forum Discussion
Excel web query DataFormat.Error "not a valid path"
It looks like XML schema for your Excel is customized, perhaps that's the reason.
Hi Simon,
Could you please attach sample workbook with this error? I queried URL with Get & Transform and see no issues - attached.
I also asked a colleague to try from their PC - same issue when starting from scratch and using just the link I provided above from Get & Transform.
Perhaps it's an issue with our organisation's systems?
It looks like XML schema for your Excel is customized, perhaps that's the reason.
OK, thanks.
I've found 2 things:
1) In my exiting workbook that used to work fine: If click connections, properties, definitions tab and then browse for a new connection file I can add the URL there and it successfully connects. The connection is already set to insert the data into a specific worksheet from an existing query. The query itself won't refresh (encounters the error above). If I delete the query the connection remains, and I can refresh the connection instead of refreshing a query.
This seems to get me out of trouble for this specific application in this workbook.
2) Any new workbooks continue to have the problem above. I can't seem to get a new connection to add data to a worksheet, and I can't get queries to successfully access this (or other) URLs that link to .xls files.
I'll ask my company IT guys if there's anything that's changed in our Excel setup over the past few months and we'll go from there!
Thank you again for your help, Sergei.
Simon, with your file I have this error
Clicking Ok couple of time after that and file refreshes correctly.
If I copy/paste your query into new workbook - no issues at all. Something is wrong with Excel itself, not with query. So far have no idea what's that.