Knowledge Base

XL98: "Cannot Paste the Data" Error When Creating Hyperlink

Article ID: 176414

Article Last Modified on 9/11/2002

Microsoft Excel 98 for Macintosh

This article was previously published under Q176414

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, if you click Paste As Hyperlink on the Edit menu, or if you drag a cell while holding down the CONTROL key on the keyboard, and then click Create Hyperlink Here on the shortcut menu, you may receive the following error message:

Microsoft Excel cannot paste the data.

CAUSE

This problem occurs if you have not saved the active workbook at least once.

RESOLUTION

To prevent this problem from occurring, save the workbook. After you save the workbook, you can create the hyperlink.

STATUS

This behavior is by design of Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

In Microsoft Excel 97 for Windows, the Paste As Hyperlink menu command is unavailable (dimmed) if you have not saved the workbook at least once. In Microsoft Excel 98 Macintosh Edition, the menu item is not dimmed, but you cannot use it unless you save the workbook.

For information about a similar problem in Microsoft Excel 97 for Windows, please see the following article in the Microsoft Knowledge Base:

156883 XL97: "Create Hyperlink Here" Does Not Work in Unsaved File

Additional query words: XL98

Keywords: kberrmsg kbprb kbfaq KB176414