Microsoft KB Archive/249888

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

Article ID: 249888

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q249888



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.



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.



WORKAROUND
To work around this issue, follow these steps:  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:  Start Microsoft Internet Explorer. On the File menu, click Open. In the Open box, select the HTML file that you want, and then click OK. In the Internet Explorer window, right-click the HTML document that you opened. On the shortcut menu, click View Source. Notice that the HTML document source code is displayed in Notepad or WordPad.

</li></ol> </li> In the document window, insert a new blank line at the location that you want the Excel data to appear.</li> On the new blank line, type the following data:

</li> On the File menu, click Save, and then close the text editor.</li> Click to select Internet Explorer.</li> On the File menu, click Save As.</li> In the File name box, type the name that you want your file to be saved as, and then click OK.</li> Quit Internet Explorer.</li> Start Excel 2000 and open the workbook that contains the selection that you want to add to the HTML document.</li> On the worksheet, select the cells that you want to add to the HTML document.</li> On the File menu, click Save As Web Page.</li> In the File name box, type the same name that you used in step 7, click to select Selection: , and then click Save.</li> Click Add to file, and then quit Excel 2000.</li> Start Internet Explorer, and then open your HTML document.</li></ol>

Notice that your Excel 2000 selection appears in your document at the location that you specified.

<div class="references_section">