Microsoft KB Archive/201467

= XL97: "Unable to Open..." Error When You Perform Web Query =

Article ID: 201467

Article Last Modified on 5/13/2003

-

APPLIES TO


 * Microsoft Internet Explorer 4.01 128-Bit Edition
 * Microsoft Internet Explorer 4.0 128-Bit Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q201467



SYMPTOMS
When you run a Web query in Microsoft Excel, you may receive the following error message

Unable to open. The connection to this Internet site took longer than the allotted time.

where  is the Uniform Resource Locator (URL) that you want to query.



CAUSE
This problem may occur when the following conditions are true:
 * You are running Microsoft Internet Explorer 4.0 or 4.01.

-and-
 * You perform a Web query that takes longer than five minutes to run.



RESOLUTION
To resolve this problem, click the article number below and follow the steps in the following article in the Microsoft Knowledge Base:

181050 Err Msg: Microsoft Internet Explorer Error 10060 Connection...



STATUS
This problem was corrected in Microsoft Internet Explorer 4.01, Service Pack 1.



MORE INFORMATION
Excel uses the same Internet settings for Web queries as Internet Explorer. Internet Explorer 4.0, 4.01, and Internet Explorer 4.01 Service Pack 1 have a default timeout setting of five minutes. Internet Explorer 4.01 Service Pack 1 lets you change the default timeout setting by modifying the Windows registry.

Additional query words: XL97

Keywords: kbweb kbprb KB201467

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.