View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tokyo4tokyo
 
Posts: n/a
Default External Web Query Errors

When using External Web Query data import function in Excel, with multiple
work sheets and multiple web queries it is difficult to identify which web
queries have an error. when "The Web Query returned no data" error message
occurs. (This is not indicated in the fx bar or cell reference box) . Would
be nice to be able to identify the cell reference location of the web query
that has the error so that it can be corrected.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions