If i understund your question well here is a work arround
Source = Here
WORKAROUND
To work around this problem, use one of the following methods.
Method 1
Rename the file with a name that does not include the pound sign, and then edit or recreate the hyperlink.
For more information about how to rename a file in Windows, see your Windows printed documentation or online Help.
To edit the hyperlink, follow these steps:
For Office 2003 and earlier versions of Office:
Right-click the cell that contains the problem hyperlink. On the shortcut menu that appears, point to Hyperlink, and click Edit Hyperlink.
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:
Right-click the cell that contains the problem hyperlink, and then point to Edit Hyperlink.
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:
Open the document that you are trying to link to (which contains the # sign in the name).
Copy the cell that you want to link to.
In your document, on the Edit menu, click Paste as Hyperlink.
For Office 2007 and Office 2010 programs:
Open the document that you are trying to link to. This is the document that contains the # sign in the name.
Copy the cell that you want to link to.
In your document, click the cell in which you want the hyperlink to appear.
On the Home tab, click the arrow below Paste in the Clipboard group, and then click Paste as Hyperlink
if you are using VBA code this line may be of help I tested it.it's working in both chrome and firefox
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=
"C:\path\to\your\file.htm", SubAddress:="nameOfYourAnchor", TextToDisplay:=
"text to display")
here nameOfYourAnchor w/o the # Sym for example if your link is C:/Users/[User]/Desktop/Intel Core - Wikipedia, the free encyclopedia.htm#Core_i3 your code will be (ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=
"C:/Users/User/Desktop/Intel Core - Wikipedia, the free encyclopedia.htm",
SubAddress:="Core_i3", TextToDisplay:=
"text to display")
hope this helped.
#
character, see the WikiPedia article, also notice the forum post and the KB articles linked to it use the same name