The shorter answer is yes. Just type into your desired cell '=hyperlink' and add whatever hyperlink you need. 2016-11-24 07:05:36. I confirm that the statement 'the only option is to unshare the workbook' is not true. There is an ugly but easy way to get an hyperlink in a shared workbook. How do I activate hyperlinks in Excel? To use the Insert Hyperlink command, follow these steps to get started: Select the cell where you want the hyperlink. On the Excel Ribbon, click the Insert tab, and click the Hyperlink command. OR, right-click the cell, and click Link. OR, use the keyboard shortcut – Ctrl + K. Why do some hyperlinks not.
Dan has a shared workbook into which he needs to insert a hyperlink. However, as long as the workbook is shared, the hyperlink features in Excel are not available. Dan wonders if there is a way to insert hyperlinks into shared workbooks.
The short answer is no, there is not. When you choose to share a workbook, some options in Excel are simply not available any more; inserting hyperlinks is one of those options that is removed once the workbook is shared.
If you absolutely must add the hyperlink to the workbook, the only option is to unshare the workbook, add the hyperlink, and then again share the workbook. You'll no longer be able to add any more hyperlinks, but the one you added while the workbook was unshared will work just fine.
There is one caveat in taking this approach to adding the hyperlink—you need to be careful that you don't unshare the workbook if you have the Track Changes feature of Excel turned on. In the process of unsharing the workbook, Excel will turn off the tracking and discard the change history. If this is important to you, the only option is to make sure that you add the hyperlinks before sharing the workbook and first turning on Track Changes.
A client called me asking for help with a problem on one of their Microsoft Excel spreadsheets. They were creating content for their new website that I was in the process of building and wanted to include bookmarks to content they had already created on the site.
Whenever they clicked on a link in their spreadsheet, they received an error “Unable to open <url>. Cannot download the information you requested”. They also tried doing it in Microsoft Word, but received a similar error.
I had them send me the spreadsheet and Word document – I don’t use Microsoft Office, but I do have the readers installed. Strangely enough, I got exactly the same error – which was very perplexing considering that the link itself was completely valid and worked in my browser.
I had them create some test links to other website and found that these worked without a problem. This proved to be a major clue to the problem – it seemed related to the website I was building rather than a problem in Word or anything else.
After a bit of Googling I found a technote that explained that the Office programs will attempt to access the link first before forwarding the URL to your browser to load the web page. If there is an error returned from the website for that URL, Word or Excel will refuse to load it.
On closer inspection I found that web pages on the site I was developing were indeed returning 404 errors. I had set up a basic layer of security prior to site launch by including a conditional in the header template of the WordPress site which checked to see if the user was logged in to WordPress as an editor or administrator, and if not – display an error message explaining the site was coming soon.
The wp_die function I was calling returned a 404 HTTP code to the browser when it output the error message – which is all that Word or Excel could get from the site – thus they believed (correctly) that the URLs were (currently) invalid. When I turned off the security to test it, the links in Word and Excel worked as expected.
Hyperlink Option Not Showing In Excel 2016
The real problem was that Word and Excel provided less than meaningful error messages – if they had just forwarded the request to access the URL to a browser, we would have seen the meaningful error message from the website and worked out what was happening immediately.
Hyperlinks Not Working In Excel 2016 File
Tags: Excel; Microsoft; Windows; Word