Finding Bad Web Queries

[Lee Harris]

If you have a sheet with multiple links to external data via Data->Import
External Data from Web
and you "refresh all" and somewhere in the process you get an error that the
web query returned no data, is there some way you can "see" the actual links
and which one went wrong? I don't want to have to manually trawl through
tens of tabs of pages to see which one isn't changing when I update. I
thought there might be an option or command that listed all the external
links with some kind of way to see which one was "bad"

tks in advance

 

[Lee Harris]

will not <debug> in the error message go to the offending line in the code
or have I not understood?

no, there's no line in any code. It's just a case of using Data->Import
External Data in different cells on different sheets