Step 3: Now, scroll down and look for the 'General' tab.Step 2: Click on 'Options' and then go to the 'Advanced' menu.Step 1: Launch Microsoft Excel and then go to the 'File' tab.Here is the procedure to disable the 'Update Links on Save' feature. However, the error can be fixed by disabling the 'Update Links on Save' feature in MS Excel. The reasons discussed earlier in the above section are usually the most common cause of Excel hyperlink can't open the specified file error. Fix Excel Hyperlink Cannot Open the Specified File by Disabling 'Update Links on save' Read Also: How to Restore Previous Version of Excel File in Windows 10? Part 2. To fix the problem, you would need to make sure that the data is saved fully before you attempt a shutdown.

The automatic update often causes the hyperlink's address to alter, which might cause the resulting error. Microsoft Excel comes with a built-in feature to update hyperlinks each time the device shuts down with an unsaved file. One potential risk of the unusual closure is discrepancies in the data stored, such as hyperlink not opening in an Excel file.

Unexpected shutdowns may cause your computer to malfunction. Unusual Shutdown or Inappropriate File Closure Step 4: In the address box, paste the copied address and click 'OK'. Step 3: Right-click on the hyperlink, and click 'Edit hyperlink' in the menu. Step 1: Copy the address of the new file from the file's explorer.

Follow the steps below to edit the address. You would need to correct the hyperlink address to the updated file name so that the file becomes detectable. Solving the error might appear a tedious task, but this would surely bring out results that you love. However, if the name of any designated location is altered, the hyperlink would fail to find it, thus, a “cannot open the specified file” error might occur. Hyperlinks help you view related information in multiple locations, including your computer network and the internet. Reasons for Hyperlinks Not Working in Excel Issue

How to disable links in excel 2010