Finding Bad Web Queries

  • Thread starter Thread starter Lee Harris
  • Start date Start date
L

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
 
will not <debug> in the error message go to the offending line in the code
or have I not understood?
 
R.VENKATARAMAN said:
will not <debug> in the error message go to the offending line in the code
or have I not understood?
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import external data link disappears 1
Pivot tables, external data sources and ODBC links 1
Sumif to multiple tabs 1
Creating a Web Query 4
Cloud Storage 11
Import Data -- External Web Query 1
Running a macro from an auto-refresh 2
Find External Links 2

Back
Top