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. XL2000: "Insert Into Existing HTML File" Option Is Missing

XL2000: "Insert Into Existing HTML File" Option Is Missing

View products that this article applies to.

This article was previously published under Q249888

↑ Back to the top

Symptoms

In Microsoft Excel 2000, you may be unable to insert data into an existing Hypertext Markup Language (HTML) document. Although Excel 97 offers the option Insert the converted data into an existing HTML file (just the table will be created), this option appears to be missing in Excel 2000.

↑ Back to the top

Cause

The Excel 97 Insert the converted data into an existing HTML file (just the table will be created) option does not exist in Microsoft Excel 2000.

↑ Back to the top

Workaround

To work around this issue, follow these steps:
  1. Use a Web browser or a text editor to edit the source code of the existing HTML Web page. To do so, follow these steps:
    1. Start Microsoft Internet Explorer.
    2. On the File menu, click Open.
    3. In the Open box, select the HTML file that you want, and then click OK.
    4. In the Internet Explorer window, right-click the HTML document that you opened.
    5. On the shortcut menu, click View Source. Notice that the HTML document source code is displayed in Notepad or WordPad.

  2. In the document window, insert a new blank line at the location that you want the Excel data to appear.
  3. On the new blank line, type the following data:
    <!--##Table##-->
  4. On the File menu, click Save, and then close the text editor.
  5. Click to select Internet Explorer.
  6. On the File menu, click Save As.
  7. In the File name box, type the name that you want your file to be saved as, and then click OK.
  8. Quit Internet Explorer.
  9. Start Excel 2000 and open the workbook that contains the selection that you want to add to the HTML document.
  10. On the worksheet, select the cells that you want to add to the HTML document.
  11. On the File menu, click Save As Web Page.
  12. In the File name box, type the same name that you used in step 7, click to select Selection:$x$x:$x$x, and then click Save.
  13. Click Add to file, and then quit Excel 2000.
  14. Start Internet Explorer, and then open your HTML document.
Notice that your Excel 2000 selection appears in your document at the location that you specified.

↑ Back to the top

References

For more information about placing Excel data on a Web page, click Microsoft Excel Help on the Help menu, type web page in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top

Keywords: KB249888, kbprb

↑ Back to the top

Article Info
Article ID : 249888
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 185