Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have been doing External Web queries in Workbooks I designed for several clients for over a year now. With a very high degree of success, we have had few problems until recently. Now when we try to run a query in MSN Money, after several queries have run, we get the following message: ....The 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.The 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... Upon using the Edit Query option, we find that our check marks for the specific Data Range(s) has been cleared. The Query seems to be intact but the Range(s) are cleared and we must review all queries and make sure the correct range(s) have been "re" checked. To make matters even more confusing, it seems if we log off and turn off the computer, later when we get on-line again, the queries will work again only to then start having the same issue of the message coming up and having to edit the query. No real pattern. The External Data Query will run a number of times and then fail again. Anyone have any ideas as to why suddenly a problem like this occurs after running successfully for over a year? Thanks for any suggestions. -- SHD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External Data Query | Excel Discussion (Misc queries) | |||
External Web Query Errors | Excel Worksheet Functions | |||
External Data Query | Excel Programming | |||
External web query from ASP | Excel Programming | |||
Query of External Data | Excel Discussion (Misc queries) |