Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing multiple XML queries into Excel | Excel Discussion (Misc queries) | |||
Moving / Sharing excel files with queries | Excel Discussion (Misc queries) | |||
change data source for many queries at once? | Excel Worksheet Functions | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) |