Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Web Query settings
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anyone Else Use Database Query to Query Another Sheet in the Same | Excel Discussion (Misc queries) | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
Web Query Help... | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |