Free Microsoft Excel 2013 Quick Reference

Web query returned no data

Hello,

I am trying to run a series of web queries in Excel 2003. I thought that the problem was in my code, but it seems to be a problem with the Web Query itself, because the problem also comes up when I do the query manually.

--In the query box, I entered the url: http://prfri-rma-map.tamu.edu/defaul...showLabel=True
--The website showed up fine.
--I selected a table so I can import the county name, etc.
--I got the error message: "This Web query returned no data. To modify the query, click OK....
--According to Microsoft, this is because the website requires a password. However, this is NOT the case.

Any ideas on what else would cause the error message? Thanks a bunch!


Post your answer or comment

comments powered by Disqus
Greetings!

I have a macro that I run which (among other things) executes a bunch of web queries to fetch stock & option prices by way of RefreshAll. There are LOTS of queries. Over time, some of these become non-functional (especially options quotes which expire every month). So I'm often getting the "web query returned no data" error. What I want to do is make it so that those errors are ignored and the RefreshAll can continue without my intervention.

While we're on the subject, does anyone know how to identify WHICH queries are non-functional? When I do the Refresh All (in the macro or manually), I just get pop-up error messages which tell me there's a web query "no results" problem, but it doesn't tell me WHERE, and when I click "OK", the refresh continues. So I never get the opportunity to see which one(s), and the message itself gives me no clues.

Thanks!

Scott <><

Hi all.

I'm having problems importing data from my own ASP.NET web site into
Excel. I create a new Web Query and enter the URL, and my data page
shows OK. I select the table in which I am interested from the window
below, but when I click Import, I get the error message:

"This Web Query returned no data. To modify the query, click OK, click
the name of the external data range in the name box on the formula bar,
and then click Edit Query on the External Data toolbar."

Agh! What is wrong here? How come it can see the data in the dialog
box, but when I come to actually import to the sheet it fails?
Selecting the entire page instead of the single table also makes no
difference.

I have been doing this from an ASP page for a long time now with no
problems. Now I have upgraded the page to ASP.NET it no longer works.
There is no password on the site. I am thinking it could have something
to do with cookies, but I am not sure.

I have seen this support page, but it doesn't help in my case:
http://support.microsoft.com/default...;EN-US;Q277596

Any help very much appreciated.

Mike

I've got a workbook that gets data via a web query and produces an export workbook, via VBA. The problem I'm having is that sometimes the table referenced in the web query doesn't exist (because the website hasn't updated); if it doesn't exist, the web-query displays an error ("This Web Query returned no data...") and the code carries on in the background.
Is there any property of the querytable I can use to check if the query is returning data, or something else I can do to make sure that the export only goes ahead if the query actually updated?

I have created an excel 2003 web query to a web application on the intranet.
To access the web application a name and password are required.
How can I integrate my login name and password into the web query allowing
excel to access the web application and automatically refresh the data?
When I hit 'refresh data' now I get the error:
This query returned no data. To modify the query, click OK, click the name
of the external data range in the name box on the formula bar, and click Edit
Query on the External Data toolbar.

I appreciate any help!

Tjeerd Klaassens
The Netherlands

Good afternoon,

I have a macro in my workbook to execute a web query on workbook open, the problem comes when the web query returns no results. Im using a VB script to open the workbook so it runs the web query and this script is being called from an SSIS package. When the web query returns no results a messagebox pops up and says:

"This Web Query returned no data. To change the query, click OK, click the arrow on the name box in the formula bar, click the name of the external data range for the Web Query, right-click the selection, and then click Edit Query."

After this messagebox pops up the script attempts to save the workbook but the attempt is unsuccesful since excel is waiting for a user to click on "OK". Is there a way to avoid this message?

1. I am trying to create a Powerpoint Presentation from an Excel sheet which
is linked to a MS-SQL database. When the queries return no data Excel will
shift the cells where the data should go up on the sheet throwing off the
links to the charts. This is UNBELIEVEABLY ANNOYING. How do I stop the
shifting of the cells. I've tried to get around by using a case statement in
the SQL but instead of retuning zeros I get nothing back and the cells shift.
I tried to use SQL.REQUEST but can't seem to get the function installed.

2. How do I set up queries in Excel that don't constantly ask me for the
password to the database?

Thanks

Joe B

Some web pages return no data for example the top ten stocks for this month
from MSN stocks lists
Can anyone say why? Other queries from other pages work fine?
Appreciate any help
Dianne Zinky

I'm trying to import data from a website. Usually I can go to the data --> From Web and enter the URL of the site I'm trying to get the data from. Everything works OK when I put the URL into the dialog and the correct page is displayed. I select the table I wish to import and then hit the IMPORT button. HOWEVER, Excel constantly says there is no data in the table, even though I could see there clearly WAS data there.

The URL I'm trying to import is:

http://www.flow935.com/newlayout/mus...tly_played.php

The table is the list of songs.

Any help would be appreciated.

I am trying to use a web query to pull a list of all Chevrolet dealers by a specific zip code in Maine. The idea is to use a URL that has been typed into a specific cell to pull the corresponding data from Chevrolet's site to obtain the dealers in this vicinity... an example of the URL is : http://www.chevrolet.com/tools/deale...00&sortOption=

The part of the URL labeled searchByPostalCodePostalCode=0463 is the part that I would like to dynamically update based on a specific area code typed into cell A1. I have tried creating an iqy file that copies the URL above with a ["URL"] substituted for the zip code where I identify the cell in the parameters section to dynamically pull the zip code. This yields a message that the Web Query returned no data. My iqy file looks like this:

WEB
1
http://www.chevrolet.com/tools/deale...odePostalCode=["zip"]&updateBt=Update&proximity=&BRANDID=ch&searchType=ByPostalCode&desiredCount=100&sortOption=

I am a novice at VBA and have attempted a few other code suggestions, but I was not able to make them work. Is it possible to achieve the result I want using the iqy file and the parameter from a cell in my workbook? I attached a basic copy of what I am trying to do.

Maine Chevrolet Dealers_test.xlsx

Hi all,

I am writing a web query for Excel 2007 to extract data from a database application via a web server that we have full control over. If the requested page is not available, the web server generates an HTML "Data not available" page, but the web query appears to only be capable of:

- displaying the generic "Unable to open (URL). Cannot download the information you requested" message
- displaying the "This Web query returned no data. To change the query, ..." message
- inserting the text of the error page into the spreadsheet (not desirable)

What I am ideally looking for is a piece of HTML (like the
TABLE  o:WebQuerySourceHRef="URL" 
redirection tag) that the server can return that will cause Excel to suppress the standard error messages, and if possible display our own one. If this is achievable at the server end that would be perfect, but a solution involving some VBA at the Excel end would be acceptable.

I've looked around for such a feature but found the documentation for the family of tags the redirection one was taken from badly lacking. I've also checked through the archive- there appear to be a number of questions about suppressing the first error message I mentioned, for various reasons. Apologies if that part of the question has already been answered, there were a lot of threads just entitled "web query" and I might have missed the odd one- if it has then just a link would be great.

Thanks for your help!

This just seems like an easy EXCEL question, but I cannot figure it out!

http://scoweb.sco.ca.gov/UCP/NoticeD...yRecID=9098419 is the website I am trying to pull date - I receive a message saying "The Web query returned no data ..." when I select the YELLOW arrows to select either of the following tables :

Business Contact Information:
GENERAL MILLS INC.
TREVOR V GUNDERSON
NUMBER 1 GENERAL MILLS BLVD
MINNEAPOLIS, MN 55426
(763) 764-5324

Type of Property: VENDOR PAYMENTS
Amount Reported: $687.58
Shares Reported: 0.0000
Date Reported: 10/25/2007
Date of Last Contact: 6/7/2004
Reported Owner Name(s): UNITED WAY OF THE BA Y AREA
Reported Address: 50 CALIFORNIA ST STE 200, CA 94111

Any help?

I am taking input from the user which is a stock symbol and returning specific information from a table. Here's the code
Code:
Sub Button1_Click()
   Dim QT As QueryTable
   Dim sourceURL As String
   Dim myTicker As String
 
   myTicker = Application.InputBox("Enter a Ticker Symbol")
   ConnectString = "URL;http://finance.yahoo.com/q/ks?s=" & myTicker
   Set QT = ActiveSheet.QueryTables.Add(ConnectString, Destination:=Range("$B$3"))
 
   With QT
       .RefreshStyle = xlOverwriteCells
       .WebTables = "28"
       .Refresh BackgroundQuery:=True
   End With
It all works great except for the case whent the user enters the wrong symbol. In that case an error message pops up saying "The web query returned no data. To change the query, click OK...".

I'd like to prevent that error and possibly reprompt the user for another ticker. I looked through the members of QT but can't see an obvious value that will helpme determine if the QT is empty. I tried 'isEmpty(QT)', but the answer is FALSE regardless of whether the user types MSFT or FOO.

Thanks.

Hello
I have a question, I'm using a relatively big file in excel as database.
I was trying to use a web query to only send the search file to people and that when they open it in their machine the web query will load the database in the excel. So only a small file is sent back and forth every time. I manage to load the query using regular html tables.
But if I try to save my existing excel database as an htm file, it comes with this weird css and although it looks ok if I go to it http://el-ja.netfirms.com/a.htm when I try to import it in excel it says:
This Web query returned no data. Modify the query ......

I don't know if it can be done, maybe usinging a web db like mysql I could manage to print a normal table. The thing is I already have a lot of info in the excel workbook and wouldn't want to type it again.
Greetz

I am doing I think the right things. I click on get data from :"get data from
web" under the data tab in my excel 2007. I click on the yellow arrow next to
the table whose data I would like to import. I then press the import button.
But I don;t get the table. Instead I get "the web query returned no data. To
change the query, click OK, click the arrow on the name box in the formula
bar, click the name of the external data range for the web query, right click
the selection, and then click edit query. "

I did all this , but no use. Could somebody please help me.

Dr Alok Modi MD

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

im trying to pull data from a pay site. I am a member to this site, have
username and password etc etc. but whenever i try to pull the web query
it gives the error

"the web query returned no data"

is there a way to implement my u/p into excel so that it automatically
logs me into the site so that it can retrieve the data?

(the site is investools)

--
JustinB
------------------------------------------------------------------------
JustinB's Profile: http://www.excelforum.com/member.php...o&userid=34886
View this thread: http://www.excelforum.com/showthread...hreadid=546293

Hi all,

I am attempting to have a list of stock symbols and have them generate a quote as well as other information detailed on yahoo's stock page. I read on the forum here that this code will work (but have been playing with it for a while now with no success).

I have in the A column and selected when I run this:

AA
DD
JNJ
PG

____
Sub Get_Nyse_Data()
Dim C As Range
Dim strName As String
Dim strConnectString
Dim QT As QueryTable
On Error Resume Next

For Each C In Selection
strName = C.Value
strConnectString = _
"URL;http://finance.yahoo.com/q?s=" & C.Value
ThisWorkbook.Worksheets.Add
ActiveSheet.Name = strName

' On the Workspace worksheet,
'clear all existing query tables
For Each QT In ActiveSheet.QueryTables
QT.Delete
Next QT

' Define a new Web Query
Set QT = ActiveSheet.QueryTables.Add _
(Connection:=strConnectString, Destination:=Range("B1"))

With QT
Selection = EntirePage
Formatting = None
PreFormattedTextToColumns = True
ConsecutiveDelimitersAsOne = True
SingleBlockTextImport = False
DisableDateRecognition = False
DisableRedirections = False
.Name = strName
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingAll
.WebTables = "23,25"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
End With

' Refresh the Query
QT.Refresh BackgroundQuery:=True

Next
End Sub
_______

It returns web query returned no data. That is unusual because it all looks like it should, I cannot figure this out any help would be greatly appreciated.

Oddly enough I'm having a problem with Excel for once!

I'm trying to perform a Web Query for the current day interest rates at U.S. Bank.

No matter what I've tried I still get 'The web query returned no data...' I've tried on Excel 2007 with IE7, Excel 2003 with IE7 and Excel 2007 with IE6.

1. Can anyone else get this query to work?
2. If not, are there any alternatives?

I've even tried reading from the locally cached version of the web page with no luck. Is there possibly a way to grab the source code from a page, after which I could parse it using VBA?

Update: I found this thread - How To Save HTML Source Code, and it works for that, but I'd prefer to find out if I can use web query or an alternative rather than start parsing the text file this macro creates.

The page itself is a .cfm file, but of course behind the scenes it's really just HTML with some Cold Fusion built in.

Thanks for any ideas..

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...heet.functions

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

I have a Excel 2007 workbook that imports data using web queries from a long (600+)series of web pages into an Excel 2007 workbook. I use the "Refresh All" option under the Data menu to update the data.

There are occasional errors each time the data refresh process is run such as: "The Web query returned no data. To change the query... etc." or "Unable to open... etc."
When these occur, a dialouge box with an "OK" button pops up and the data refresh process stops until I click OK.

The inability to access data on a few pages is inconsequential to my application. I'm looking for an error handling option that would ignore these web page access errors and let the data refresh process run continuously through the long list of webpages to the end.
I don't want to delete or edit the web queries either because the errors are often transient.

Anybody have a suggestion?

Hi foks,

I have several workbooks with 20+ worksheets to access a server on the web.
The web query for each worksheet accesses a table on a specific web page. If
I pick the wrong time of the day to replicate these files (when they are
working on the database on the server), obviously the data doesn't refresh.
There are other occasions when data won't replicate, when certain accounts
unsubscribe to the service offered on the web site.

My question is, when I get the "This web query returned no data ... etc."
error message, I don't get get the same message on all twenty worksheets.
Some error messages on certain worksheets will say it can't refresh data
from the specific web address. Getting the web address error message is more
useful to yours truly, as I know which specific worksheet to checkout and
possibly remove from the workbook.

I've checked all my settings under the query, and under the query options
page and don't see any differert settings between those worksheets where I
get the basic web query returned no data statement, and the error statement
which includes the web page.

Are there any other places to look under the menus to see why I'm different
statements?

TIA,

Bob

Good afternoon,

I have a macro on my workbook_open() method like this:

    With
ActiveWorkbook.Connections("Connection")
        .Name = "Connection"
        .Description = ""
    End With
    Range("A1").Select
    
    With Selection.QueryTable
        .Connection = Get_URL
        .WebSelectionType = xlEntirePage
        .WebFormatting = xlWebFormattingAll
        .WebPreFormattedTextToColumns = False
        .WebConsecutiveDelimitersAsOne = False
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .WebDisableRedirections = True
        .Refresh BackgroundQuery:=False
    End With
    Range("A1").Select
    ActiveWorkbook.Connections("Connection").Refresh
I am opening this workbook in a VB script like this:

dir =
CreateObject("Scripting.FileSystemObject").GetParentFolderName(Wscript.ScriptFullName)
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False

Set objWorkbook = objExcel.Workbooks.Open(dir & "Variacion_Interanual.xlsm")
wscript.sleep 15000
objWorkbook.Save
objWorkbook.Close
The problem is that when the web query returns no data, it displays a messagebox which requires user interaction to click on "YES".

Is there a way to prevent this messagebox to appear?

If I try and use a web query with the following site
http://www.sportsline.com/mlb/stats/...n/yearly/MLB/P

I get a message that says the web query returned no data. I click on the
arrow right by player and it highlights all the players names and their
stats. Anyone know why it doesn't import the data into excel? Is there too
much data? Thanks


No luck finding an answer? You could always try Google.