Microsoft KB Archive/249888: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - "<" to "<")
Line 74: Line 74:
<div class="indent">
<div class="indent">


<p><span class="kbd userinput"> &lt;!--##Table##--&gt;</span></p>
<p><span class="kbd userinput"> <!--##Table##--&gt;</span></p>


</div></li>
</div></li>

Revision as of 09:00, 21 July 2020

Knowledge Base


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:

  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: