Forum Discussion
Solved
Excel web query DataFormat.Error "not a valid path"
Hi, I have a workbook that grabs data from a few online Excel workbooks. This was working fine from when I set it up about six months ago until recently, when it started producing a DataFormat.E...
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.
It wasn't working in my attached file. Screenshot of the query editor below showing the error and source.
My file
When I opened your file and refreshed the query I got the same error again! See screenshot below, after trying to refresh the query.
Sergei's file
Apparently I didn't attached my file above.
It's here now.