Microsoft KB Archive/277612

= Table markers do not appear when you perform a Web Query in Excel on a secure Web site =

Article ID: 277612

Article Last Modified on 6/27/2007

-

APPLIES TO


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

-



This article was previously published under Q277612





SYMPTOMS
When you try 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 in the &quot;Applies to&quot; section.



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:  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?

  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.</li> 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.</li></ul> </li></ol>

For more information on Web Queries and secure web pages in Microsoft Excel 2002, click the following article number to view the article in the Microsoft Knowledge Base:

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

Additional query words: XL2002 XL2007 XL2K7 XL2003 XL2K3

Keywords: kbbug kbpending KB277612

-

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

© Microsoft Corporation. All rights reserved.