Several causes can lead to this symptom of non-clickable links. There are several possible reasons for this, and several ways to correct the problem. Here we give some recipes. We recommend considering them in this order, but it is not an obligation.<\/p>\n
Office version<\/h2>\n
It is with Excel 2003 (so more generally with Microsoft Office 2003) that the problems are most frequent. If you have the option to use another version of Office, this can very effectively solve non-clickable link issues. Remember that Microsoft Office is not the only available programme, but there\u2019s also Free Office (or Open Office), free and just as powerful as Microsoft’s paid programmes. Files distributed by the Club can easily be used in Libre\/OpenOffice. You just have to pay attention to one detail: to open a link with the mouse, you have to keep the CTRL button pressed when clicking. But you will get an info-bubble reminder when you go to the link with the mouse, so that there\u2019s no danger of forgetting it.<\/p>\n
Mac users can use Numbers instead of Excel.<\/p>\n
CopY and paste<\/h2>\n
One solution to links that don’t open with a simple click is to copy the address and paste it into the web browser. In the case of links from the colcatalogues to the col viewer<\/a>, the link does not appear in the cell, where only the code is visible. It is then necessary to remove the protection of the sheet if it is active (possible without password), select the cell and then copy the link from the formula at the top of the window, i.e. everything from http to the col code (as in the image).<\/p>\n In Windows, a setting can in some cases provide the solution. Here’s how:<\/p>\n Sometimes the problem of non-clickable links is related to secure connections of the type https (as opposed to unsecured https). It must be said that when Office 2003 (which poses the most problems) was put on the market, the secure sites were still only in a small minority, whereas they are now in the majority. So we have prepared a small test file<\/a> to download that lets you know if the https is involved. After downloading this file, try clicking on each of the two available links. If the first works but not the second, then one solution is to systematically replace the https links with http links in your files. But it should be noted that many secure sites simply no longer allow unsecured access, and then this replacement will do no good. In the case of links from the col catalogues, it is possible: see the following topic.<\/p>\n If the above test revealed a problem with the https, a change to the colcatalogues may allow them to click the links to the col viewer<\/a>. Here’s how to do it in detail (the procedure being repeated for each catalogue):<\/p>\n If Internet Explorer is installed on your computer in a 10 or older version, then it may pose a problem even if another web browser is used by default! Make sure Internet Explorer is not set to work offline, either by its file menu, tool menu or toothed wheel symbol. Offline work should not be checked. Note that since Windows 7 SP1 and the new versions of Internet Explorer and Then Edge that are installed with, this offline setting no longer exists, so it can no longer be involved.<\/p>\n If none of the previous solutions has yielded the desired result and you are working on Windows with MS Office, then an operation based on registries may be the right remedy. To do this write to assistance@centcols.net by giving the information below. Please note that if we do not have this complete information, we will not be able to offer you a suitable solution. In addition, you should be aware that this solution will require you to have admin rights on the Windows computer in question. If not, there is no need to write to us. If nothing has worked, go back to the copy and paste point. This may beonly a stop-gap, but at least it should still work, no matter what your computer settings are.<\/p>\n","protected":false},"excerpt":{"rendered":" In general Links to web pages are often included in Office files. For example, the Club des Cent Cols pass catalogues contain links to a page that allows you to view the position of any col on a map as well as other documents: it’s called the col viewer. Unfortunately, it is not uncommon for […]<\/p>\n","protected":false},"author":69,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ub_ctt_via":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[273],"tags":[],"acf":[],"featured_image_urls":{"full":"","thumbnail":"","medium":"","medium_large":"","large":"","1536x1536":"","2048x2048":"","woocommerce_thumbnail":"","woocommerce_single":"","woocommerce_gallery_thumbnail":""},"post_excerpt_stackable":" In general Links to web pages are often included in Office files. For example, the Club des Cent Cols pass catalogues contain links to a page that allows you to view the position of any col on a map as well as other documents: it’s called the col viewer. Unfortunately, it is not uncommon for such links not to be clickable, i.e. nothing happens when you click on them. Several causes can lead to this symptom of non-clickable links. There are several possible reasons for this, and several ways to correct the problem. Here we give some recipes. We recommend…<\/p>\n","category_list":"Tutorials<\/a>","author_info":{"display_name":"Enrico Alberini","author_link":"https:\/\/centcols.org\/backup\/en\/author\/5065\/"},"comments_num":"0 comments","featured_image_urls_v2":{"full":"","thumbnail":"","medium":"","medium_large":"","large":"","1536x1536":"","2048x2048":"","woocommerce_thumbnail":"","woocommerce_single":"","woocommerce_gallery_thumbnail":""},"post_excerpt_stackable_v2":" In general Links to web pages are often included in Office files. For example, the Club des Cent Cols pass catalogues contain links to a page that allows you to view the position of any col on a map as well as other documents: it’s called the col viewer. Unfortunately, it is not uncommon for such links not to be clickable, i.e. nothing happens when you click on them. Several causes can lead to this symptom of non-clickable links. There are several possible reasons for this, and several ways to correct the problem. Here we give some recipes. We recommend…<\/p>\n","category_list_v2":"Tutorials<\/a>","author_info_v2":{"name":"Enrico Alberini","url":"https:\/\/centcols.org\/backup\/en\/author\/5065\/"},"comments_num_v2":"0 comments","featured_image_src":null,"_links":{"self":[{"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/posts\/45631"}],"collection":[{"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/users\/69"}],"replies":[{"embeddable":true,"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/comments?post=45631"}],"version-history":[{"count":0,"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/posts\/45631\/revisions"}],"wp:attachment":[{"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/media?parent=45631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/categories?post=45631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centcols.org\/backup\/en\/wp-json\/wp\/v2\/tags?post=45631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Copier](\"https:\/\/centcols.org\/backup\/wp-content\/uploads\/2019\/05\/hyperlien-500x94.png\")
This general method works, but it is a bit tedious. Fortunately, for the cols, there is a simplified method. You should open the viewer page directly on the site, which is in the \u201ccartes et photos\u201d section of the col menu, and whose address is https:\/\/centcols.org\/backup\/util\/geo\/visuGen.php. On this page, there is a box at the top right in which you can enter the code of any col. It is not, strictly speaking, a solution to the problem of non-clickable links, but it is a way of doing things that always works well. One can even recommend putting the page listed among its bookmarks,so as to find it easily.<\/p>\nAllow registration of protected pages\u00a0
![\"Options](\"https:\/\/centcols.org\/backup\/wp-content\/uploads\/2019\/05\/optionsinternet-426x500.png\")
<\/h2>\n\n
Test with unprotecded connection<\/h2>\n
Unprotecded connection to the col viewer<\/h2>\n
\n
\nIt is recommended but not necessary to put the protection back on the worksheet (because this prevents changes that could cause problems if you want to later combine an old file with lines representing new cols).<\/li>\nLast thing – easy<\/h2>\n
Last thing – complicated<\/h2>\n
\n1. Enter your version of Windows, including whether it’s a 32 or 64-bit version (click on the computer symbol and then on properties).
\n2. Include your version of Office, including whetherit’s 32 or 64 bits (click \u201caide\u201d or \u201c?\u201d and then \u201ca propos\u201d).<\/p>\nBack again…<\/h2>\n