You cannot use a pound character in a file name for a hyperlink in an Office program

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

Symptoms
When you create a hyperlink to another file, the file name that appears in the hyperlink text may appear to be different than the actual file name. For example, a hyperlink to a file with the following file name:
C:\My Documents\Book#One.xls

may appear as follows:
C:\My Documents\Book - One.xls

Also, when you attempt to click the hyperlink, you may receive thefollowing error message:
Cannot Open the Specified File.
Cause
These problems may occur when the name of file to which you create the hyperlink contains a pound sign (#).

NOTE: The pound sign is a valid character to use in a file name but is not accepted in hyperlinks in Office documents.
Workaround
To work around this problem, use one of the following methods.

Method 1

Rename the file with a name that does notinclude the pound sign, and then edit or recreate the hyperlink.

For more information about how to rename a file in Windows, see yourWindows printed documentation or online Help.

To edit the hyperlink, follow these steps:

For Office 2003 and earlier versions of Office:
  1. Right-click the cell that contains the problem hyperlink. On the shortcut menu that appears, point to Hyperlink, and click Edit Hyperlink.
  2. In the Type the file or Web page name box, type the name of the file that you are linking to. If you do not know the name of the file, click File and browse to the file. Click OK.

For Office 2007 and Office 2010 programs:
  1. Right-click the cell that contains the problem hyperlink, and then point to Edit Hyperlink.
  2. In the Address box, type the name of the file that you are linking to. If you do not know the name of the file, use the search tools on the Look in... line to locate the file. Select the file, and then click OK.

Method 2

Use the Paste as Hyperlink command:

For Office 2003 and earlier versions:
  1. Open the document that you are trying to link to (which contains the # sign in the name).
  2. Copy the cell that you want to link to.
  3. In your document, on the Edit menu, click Paste as Hyperlink.


For Office 2007 and Office 2010 programs:
  1. Open the document that you are trying to link to. This is the document that contains the # sign in the name.
  2. Copy the cell that you want to link to.
  3. In your document, click the cell in which you want the hyperlink to appear.
  4. On the Home tab, click the arrow below Paste in the Clipboard group, and then click Paste as Hyperlink.
2000RTMPublic OFF2000 kboffice12yes OFF2007 OFF2010
Properties

Article ID: 202261 - Last Review: 08/12/2015 20:00:00 - Revision: 9.0

Microsoft Office Access 2007, Microsoft Office Access 2003, Microsoft Access 2002 Standard Edition, Microsoft Office Excel 2007, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition, Microsoft FrontPage 2002 Standard Edition, Microsoft Office Outlook 2007, Microsoft Office Outlook 2003, Microsoft Outlook 2002 Standard Edition, Microsoft Office PowerPoint 2007, Microsoft Office PowerPoint 2003, Microsoft PowerPoint 2002 Standard Edition, Microsoft PowerPoint 2000 Standard Edition, Microsoft Office Publisher 2007, Microsoft Office Publisher 2003, Microsoft Office Word 2007, Microsoft Word 2002, Microsoft Word 2000, Microsoft Access 2010, Microsoft Excel 2010, Microsoft Outlook 2010, Microsoft Word 2010, Microsoft PowerPoint 2010, Microsoft Excel 2013, Microsoft Word 2013, Microsoft PowerPoint 2013, Microsoft Outlook 2013

  • kbprb kbweb KB202261
Feedback