Microsoft KB Archive/827404

= You receive a nonsecure items message in Internet Explorer when you open an HTML workbook that does not contain nonsecure items in Excel =

Article ID: 827404

Article Last Modified on 1/23/2007

-

APPLIES TO


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

-



SYMPTOMS
You save a Microsoft Excel multi-sheet workbook as a Web page (.htm or .html file). Then, you use Secure Sockets Layer (SSL) to view the workbook from a Web site in Microsoft Internet Explorer 6 or in a later version of Windows Internet Explorer. When you do this, you receive the following message:

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

The workbook does not contain nonsecure items. The message is misleading.



CAUSE
Excel adds script code in the workbook. The script code adds empty HREF tags to frames that are controlled by script. Because of a change in Internet Explorer behavior, Internet Explorer treats an empty HREF tag as an HTTP resource. Internet Explorer treats this HTTP resource as insecure because the page itself came from an HTTPS Web site. Therefore, you receive the message about the nonsecure items.



WORKAROUND
To work around this problem, save the workbook as a single file Web page (.mht or .mhtml file). To do this, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2007

 * 1) Click the Microsoft Office Button, and the click Save As.
 * 2) In the Save as type box, click Single File Web Page (*.mht; *.mhtml).
 * 3) Type the file name in the File name box, and then click Save.

Microsoft Office Excel 2003 and earlier versions of Excel

 * 1) On the File menu, click Save as Web Page.
 * 2) In the Save as type box, click Single File Web Page (*.mht; *.mhtml).
 * 3) Type the file name in the File name box, and then click Save.

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12 excel2003 excel2k3 excel11 xl2003 xl2k3 xl11 excel2002 excel2k2 excel10 xl2002 xl2k2 xl10

Keywords: kbexpertisebeginner kbopenfile kbinfo kbprb kberrmsg KB827404

-

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

© Microsoft Corporation. All rights reserved.