Microsoft KB Archive/246196

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:12, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


XL97: Hyperlink Created by HYPERLINK Function Is Not Preserved in HTML File

Article ID: 246196

Article Last Modified on 10/22/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q246196


SYMPTOMS

When you view a Hypertext Markup Language (HTML) file created by the Internet Assistant Wizard, some of the hyperlinks may not be functional. They may appear to be hyperlinks, but when you place the mouse pointer over the link in your browser, the shape of the pointer does not change to that for a hyperlink.

CAUSE

This problem may occur if the hyperlink was created by the HYPERLINK function.

RESOLUTION

To resolve this problem, re-create your HTML file in Excel and replace all hyperlinks that use the HYPERLINK function, with hyperlinks created with the Insert Hyperlink dialog box.

To replace a hyperlink that uses the HYPERLINK function with a hyperlink that uses the Insert Hyperlink dialog box, follow these steps:

  1. Select the cell in which you want to replace the hyperlink.
  2. On the Edit menu, click Copy.
  3. On the Edit menu, click Paste Special.
  4. In the Paste Special dialog box, click Values and then click OK.
  5. On the Insert menu, click Hyperlink.
  6. In the Insert Hyperlink dialog box type the address for the hyperlink (for example, type http://www.microsoft.com) and then click OK.
  7. Repeat the previous steps for each hyperlink that you want to convert.
  8. Re-save your Excel file as an HTML file.



Additional query words: XL97

Keywords: kbprb KB246196