XL2001: "Microsoft Excel Cannot Paste the Data" Error When You Create Hyperlink

Article translations Article translations
Article ID: 274784 - View products that this article applies to.
This article was previously published under Q274784
Expand all | Collapse all

SYMPTOMS

When you hold down CONTROL and drag a cell that contains text or a value to a new location, a shortcut menu appears. If you click Create Hyperlink Here on the shortcut menu, you receive the following error message:
Microsoft Excel cannot paste the data.
The cell is not copied to the new location and no hyperlink is created.

WORKAROUND

To work around this problem, follow these steps:
  1. Select the cell to copy.
  2. Hold down OPTION and drag the cell to the new location.

    Excel creates a copy of the cell in that location.
  3. Hold down CONTROL, click the new cell, and then click Hyperlink on the shortcut menu.
  4. In the Insert Hyperlink dialog box, click the Document tab.
  5. Under Anchor, click Locate.
  6. In the Type in the cell reference box, type the cell reference to the cell that you used in step 1. Click OK.
Excel creates a copy of the original cell that contains a hyperlink to the original cell location.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

If you copy a cell and click the Edit menu, the Paste as Hyperlink menu command is unavailable (appears dimmed). However, if you copy a cell and switch to another Microsoft Office 2001 program, the Paste as Hyperlink command is available on the Edit menu, and you can paste the copied text or value and a hyperlink to the source cell.

In Microsoft Excel 98 Macintosh Edition, the Paste as Hyperlink menu command is unavailable (appears dimmed) if you have not saved the workbook at least once. In Microsoft Excel 2001 for Mac, the menu item also appears dimmed, but you cannot save the workbook to resolve the problem.

For additional information about the problem in Excel 98, click the article number below to view the article in the Microsoft Knowledge Base:
181704 XL98: 'Create Hyperlink Here' Does Not Work in Unsaved File

Properties

Article ID: 274784 - Last Review: January 29, 2007 - Revision: 1.1
APPLIES TO
  • Microsoft Excel 2001 for Mac
Keywords: 
kbbug kberrmsg kbfaq kbpending KB274784
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com