Finding Bad Web Queries
 

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

Finding Bad Web Queries
 

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


"Lee Harris" wrote in message
...
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

Finding Bad Web Queries
 

"R.VENKATARAMAN" wrote in message
...
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