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.
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.