Remove the ‘#’ character from the name of the file. Go the location where the file is stored, right-click on the file, and click Rename. From the Address box, copy the address of the file you are linking to. Right-click the cell containing the hyperlink that is not working, and click Edit Hyperlink. Open the file that contains the ‘#’ sign and rename it by following these steps. Solution – Rename the file name and remove the pound sign Note: While you can use a pound character in a file name, it cannot be used in hyperlinks in an MS Office document. That is because the pound sign is not accepted in hyperlinks and may lead to the ‘Cannot open the specified file’ error. When you create a hyperlink for a file in Excel, you cannot use a pound character (#) in the file name that appears in the hyperlink. Next, in the hyperlink address, replace the current filename with the renamed one in the hyperlink address. For this, right-click the hyperlink and select ‘Edit the hyperlink’. Solution – Link to the renamed fileĮnsure that the links in the Excel file are updated and points to the renamed file. If the file name that appears in the hyperlink text is different than the actual file name, it will prevent the hyperlink from working. Here are some of the possible causes behind the ‘hyperlinks not working’ issue and solutions to fix it: Cause 1 – Change in the name of the hyperlinked file Still unable to open hyperlink in Excel?Ĭauses of ‘hyperlinks not working in Excel’ problem, and solutions thereof. Causes of ‘hyperlinks not working in Excel’ problem, and solutions thereof. To a specific location on the Internet or an Intranet in the URL format. stored on a server using a Universal Naming Connection (UNC),. 
*In summary, the location can be any of the following: *If you don’t supply the function with a friendly_name, the HYPERLINK function will display link_location as the friendly_name. If it is supplied as a text string, the text should be in “quotation marks”. * Link_location can be supplied as a cell reference that contains the link path or as a text string. Ĭ4 contains the target and B4 houses the friendly name. I nsert the formula =HYPERLINK(C4, B4) and press Enter. Next up, we create a hyperlink from a file, a worksheet, and a friendly_name.Press Enter on your keyboard to display the clickable hyperlink in blue.This is because cell C3 contains our Target link to build a hyperlink from and B3 has the friendly_name.įigure2. Click on the cell where the hyperlink would be displayed ( D3 ) and insert the formula =HYPERLINK(C3,B3).Open the working spreadsheet containing cells for the friendly name, Target, and cells where the clickable hyperlink would be generated to.
Let’s follow a step-by-step guideline below: Let’s start by converting the web page in cell C3 into a clickable Hyperlink.
There are two items on the spreadsheet that should be converted to a clickable Hyperlink, one is a web page and the other is the file. This would be returned in as clickable hyperlink in blue color.
friendly_name – The link text that would be displayed in a cell. link_location – path to the page or file to be opened when clicked. Also, the Excel HYPERLINK function can also be used to build links to pages on the Internet, locations of workbooks, or files that have been stored on network servers. You can make use of the Excel HYPERLINK function to establish a clickable Hyperlink with the given formula. The Microsoft Excel HYPERLINK function is used to help return a Hyperlink from a specific destination as well as a “friendly name”. Excel HYPERLINK Function What is the Excel HYPERLINK function?
0 kommentar(er)
