{"id":8996,"date":"2022-02-15T09:55:48","date_gmt":"2022-02-15T09:55:48","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=8996"},"modified":"2024-03-28T11:03:15","modified_gmt":"2024-03-28T11:03:15","slug":"hyperlink-cannot-open-specified-file","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/","title":{"rendered":"Hyperlink Cannot Open Specified File in Excel"},"content":{"rendered":"\n

In many situations, people can be very frustrated when something goes wrong. Especially if it is something that usually works without any issues.<\/p>\n\n\n\n

One of those things is hyperlinks in Excel<\/strong>. We will show how to fix the issues with hyperlinks in Excel in the text below.<\/p>\n\n\n\n

Fix for: Name Change<\/h2>\n\n\n\n

Hyperlinks in Excel<\/strong> can link to a file, website, or to a certain cell in another worksheet in existing or in another workbook.<\/p>\n\n\n\n

To see all the options, we can simply right-click on any cell in our Excel and then click on the Link option<\/strong>:<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n\n\n\n

When we click on this icon, this is the window that we see:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

We see that we have options to insert hyperlinks to an existing file or web page, place them in the document, e-mail address, or we can create a new document.<\/p>\n\n\n\n

For our exercise, we will link an existing file that is located in the current folder (in a folder where our Excel file is also located) called Hyperlink.docx<\/strong>. We will then click OK<\/strong>.<\/p>\n\n\n\n

Now we have a hyperlink linked to the text in cell A2<\/strong> (\u201eHere\u201c)<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

When we hover over this text, we will see the location of our hyperlink. When we click on it, our word file will be opened.<\/p>\n\n\n\n

The first problem that we could encounter is that someone changes the name of our word file. Let us say that we changed its name from Hyperlink.docx<\/strong> to Hyperlink1.docx<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

When we get back to our workbook and click on the hyperlink, we will get the following error message<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

What we need to do is edit our hyperlink. To do this, we will again right-click on the cell where the hyperlink is located and click Edit hyperlink<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

We will choose the right file and click OK<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

Fix for: Hash Sign<\/h2>\n\n\n\n

The second problem you can face is that you will be unable to open the file if it has the hash or \u201c#\u201d sign<\/strong> in the name. If we change the name of our file to be Hyperlink1#.docx<\/strong>, we will still be able to open up the file. We will also edit the hyperlink in the Excel file, but will still have the same error message, i.e. \u201cCannot open the specified file\u201d.<\/strong><\/p>\n\n\n\n

This is the hyperlink that we cannot open:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

We need to rename our file name again to be Hyperlink1.docx<\/strong>, not to have a hash sign<\/strong>. Once we do, we will not have the error message again.<\/p>\n\n\n\n

Fix for: Shutdown<\/h2>\n\n\n\n

Another issue that you can face is when our system has a sudden shutdown, or we are forced to close Excel files due to some error. We will be unable to open our links in this situation.<\/p>\n\n\n\n

Luckily, Excel has an option to update the hyperlinks every time the workbook is saved. For this to run smoothly, you could probably first enable the auto-saving option.<\/p>\n\n\n\n

To ensure our links are updated on saving, we need to go to the File tab >> Options >> Advanced<\/strong>.<\/p>\n\n\n\n

Once there, we will scroll to the General tab<\/strong> and click on the Web Options<\/strong>.<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

When we click on it, a new window appears. On this window, we need to go to the Files tab<\/strong> and select the option Update Links on save<\/strong>.<\/p>\n\n\n\n

We click OK<\/strong> and this option is saved for future use.<\/p>\n\n\n\n

\"Graphical<\/figure>\n","protected":false},"excerpt":{"rendered":"

In many situations, people can be very frustrated when something goes wrong. Especially if it is something that usually works without any issues….<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"\nHyperlink Cannot Open Specified File in Excel<\/title>\n<meta name=\"description\" content=\"will get an error message. Learn how to fix the issues with hyperlinks in Excel including name changes in this article.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hyperlink Cannot Open Specified File in Excel\" \/>\n<meta property=\"og:description\" content=\"will get an error message. Learn how to fix the issues with hyperlinks in Excel including name changes in this article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-15T09:55:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T11:03:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Hyperlink Cannot Open Specified File in Excel\",\"datePublished\":\"2022-02-15T09:55:48+00:00\",\"dateModified\":\"2024-03-28T11:03:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/\"},\"wordCount\":563,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/\",\"name\":\"Hyperlink Cannot Open Specified File in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png\",\"datePublished\":\"2022-02-15T09:55:48+00:00\",\"dateModified\":\"2024-03-28T11:03:15+00:00\",\"description\":\"will get an error message. Learn how to fix the issues with hyperlinks in Excel including name changes in this article.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hyperlink Cannot Open Specified File in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hyperlink Cannot Open Specified File in Excel","description":"will get an error message. Learn how to fix the issues with hyperlinks in Excel including name changes in this article.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/","og_locale":"en_US","og_type":"article","og_title":"Hyperlink Cannot Open Specified File in Excel","og_description":"will get an error message. Learn how to fix the issues with hyperlinks in Excel including name changes in this article.","og_url":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/","article_published_time":"2022-02-15T09:55:48+00:00","article_modified_time":"2024-03-28T11:03:15+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Hyperlink Cannot Open Specified File in Excel","datePublished":"2022-02-15T09:55:48+00:00","dateModified":"2024-03-28T11:03:15+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/"},"wordCount":563,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/","url":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/","name":"Hyperlink Cannot Open Specified File in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png","datePublished":"2022-02-15T09:55:48+00:00","dateModified":"2024-03-28T11:03:15+00:00","description":"will get an error message. Learn how to fix the issues with hyperlinks in Excel including name changes in this article.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-description-automatically-generated-with-me-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/hyperlink-cannot-open-specified-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Hyperlink Cannot Open Specified File in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8996"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=8996"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8996\/revisions"}],"predecessor-version":[{"id":9015,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8996\/revisions\/9015"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=8996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=8996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=8996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}