Error message when you use Web query to a secure Web page (HTTPS://) in Excel: "Unable to open"

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q290347
In Microsoft Excel, when you create a Web query from a site that uses the Secure Hypertext Transfer Protocol (https://), you may receive an error message that resembles the following error message:
Unable to open address. Cannot download the information you requested.
Note In this message, address is the Uniform Resource Locator (URL) of the secure Web page that you are trying to connect to.
This issue occurs when Excel cannot initiate a connection because of the settings on the secure Web server.
To test whether Excel is able to connect to a particular Web page, follow these steps:
  1. In Microsoft Office Excel 2003 or in Microsoft Excel 2002, click Open on the File menu.

    In Microsoft Office Excel 2007, click the Microsoft Office Button, and then click Open.
  2. In the File name box, type the Uniform Resource Locator (URL) of the secure Web page that you want to open, and then click Open.
If you cannot open the Web page, Excel cannot connect to the secure Web page, and you cannot create a Web query.
XL2002 prb XL2003 XL2007

Article ID: 290347 - Last Review: 05/07/2007 21:27:30 - Revision: 2.2

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition

  • kberrmsg kbpending kbprb KB290347