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