Knowledge Base

WD98: Hyperlink Is Lost When Link Dragged from Word to Excel

Article ID: 178325

Article Last Modified on 10/4/2002


APPLIES TO


This article was previously published under Q178325

SYMPTOMS

When you drag a hyperlink from a Word document to a Microsoft Excel workbook, the hyperlink is lost.

CAUSE

By design, Word uses Rich-Text Format (RTF) when you drag or copy text. Because Excel does not accept RTF-formatted text, the hyperlink is lost and you see only the text.

WORKAROUND

To work around this problem, use the Copy Hyperlink command to copy the hyperlink from Word, and then in Excel, use the Paste Hyperlink command. To do this, follow these steps:

  1. In Word, right-click the hyperlink.
  2. On the shortcut menu, point to Hyperlink, and then click Copy Hyperlink.
  3. In Excel, click the cell where you want to paste the hyperlink.
  4. On the Edit menu, click Paste Hyperlink.
Additional query word: OFF98

Keywords: kbprb KB178325