Web Query Timeout

plw101

New Member
Joined
Dec 16, 2005
Messages
2
I have just discovered the joys of web query from excel, but sometimes have a situation where the server fails to respond at all and excel just freezes for ages.
Does anyone know how to put a timeout on the query, so that if this happens, it will give up after say 2 minutes ?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,118,534
Messages
5,572,741
Members
412,482
Latest member
arooshrana2
Top