Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

Symptoms

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.

↑ Back to the top

Cause

This issue occurs when Excel cannot initiate a connection because of the settings on the secure Web server.

↑ Back to the top

More Information

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.

↑ Back to the top

Keywords: kb, kbprb, kbpending, kberrmsg, kbfreshness2006, kboffice12yes, kbpubtypepublic, kbcsapac

↑ Back to the top

Article Info
Article ID : 290347
Revision : 10
Created on : 8/20/2020
Published on : 8/21/2020
Exists online : False
Views : 122