XL2002: Table Markers Do Not Appear When You Perform a Web Query on a Secure Site (277612)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q277612

SYMPTOMS

When you attempt to use a Web Query to import external data from a secure Web site, the table marker icons do not appear on the Web page.

You expect the table marker icons to appear so that you can select the tables that you want to import.

CAUSE

This problem can occur when you click No in response to the following message that appears when you navigate to the secure site:

This page contains both secure and nonsecure items.
Do you want to display the nonsecure items?

WORKAROUND

To work around this problem, click Yes in response to the messages that appear when you navigate to a secure Web site.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

When you type a Universal Resource Locator (URL) address for a secure Web site (https://) in the New Web Query dialog box, and then click GO, the following behavior occurs:
  1. The following message may appear:

    You are about to leave a secure Internet connection. It will be possible for others to view information you send.
    Do you want to continue?

    • If you click Yes, the following message appears: This page contains both secure and nonsecure items.
      Do you want to display the nonsecure items?
    • If you click No, the following message appears:

      This page contains both secure and nonsecure items.
      Do you want to display the nonsecure items?

  2. The following Security Information dialog box appears: 
    This page contains both secure and nonsecure
items.

Do you want to display the nonsecure items?
    • If you click Yes, the secure Web site appears and you are able to select, and then import the tables that you want.
    • If you click No, the secure Web site appears but the arrow icons next to the tables that may be imported do not appear, and you are unable to import the tables that you want.
For additional information on Web Queries and secure web pages in Microsoft Excel 2002, click the article number below to view the article in the Microsoft Knowledge Base:

290347 XL2002: "Unable to Open" Error When You Use Web Query to a Secure Web Page (HTTPS://)

Modification Type:MajorLast Reviewed:4/21/2001
Keywords:kbbug KB277612
©2002 Microsoft Corporation. All rights reserved.