Article ID: 274784 - View products that this article applies to.
This article was previously published under Q274784
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:
The cell is not copied to the new location and no hyperlink is created.
Microsoft Excel cannot paste the data.
To work around this problem, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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:
(http://support.microsoft.com/kb/181704/EN-US/ )XL98: 'Create Hyperlink Here' Does Not Work in Unsaved File
Article ID: 274784 - Last Review: January 29, 2007 - Revision: 1.1
Contact us for more help
Connect with Answer Desk for expert help.