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