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.
It seems to be happening on all of our spreadsheets with dropbox URLs, but only dropbox URLs. Other non-dropbox URLs work. What’s interesting is that when I simply copy the URL address from excel’s hyperlink window and paste it directly into a web browser, the Dropbox file opens without a problem.
Word / Excel hyperlinks to redirected page fail. They added a redirect and its all working fine now. Edited Dec 9, 2016 at 20:19. That would not work for our. Hyperlinks automate Excel 2016 worksheets by making the opening of other Office documents and Excel workbooks and worksheets just a mouse click away. It doesn’t matter whether these documents are located on your hard drive, a server on your LAN (Local Area Network), or web pages on the Internet or a company’s intranet. Excel 2016 Pro Training - by ClipTraining Lesson 4. Hyperlinks No Longer Work in a Workbook (Microsoft Excel). Hyperlinks Not Working in Excel for Office 365 ProPlus - Microsoft Community. 3 Ways To Fix Excel Hyperlinks Not Working Problem.
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.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Hyperlinks Not Opening In Excel
Symptoms
After a user inserts a hyperlink to a file residing on a network mapped drive within an Office product, the hyperlink's text displays the network mapped drive path, however the link is resolved as the UNC path.
For example, in Excel if you go to Insert, and then click on Hyperlink the user is prompted to select the file. If the user navigates to a file residing on a Network Mapped Drive, and inserts a hyperlink to that file, the hyperlink will be created to the file via its UNC path instead of its network mapped drive path. After the link has been inserted, the user can then hover over the link and see that the full UNC path has been used when creating the link to the file.
Cause
The cause is due to the way Office creates hyperlinks to files. Office products will create links to files using the UNC path and will not use the network mapped drive location, even if it displays it in the hyperlink text.
Resolution
There is no resolution for this. Microsoft recommends that users insert hyperlinks using the UNC path to prevent confusion in cases where opening a file via UNC or network mapped drive might make a difference in the expected behavior in the file.
Hyperlinks Not Working In Excel 2016 Download
More Information
An example of where how a file is opened can be found listed in this KB article under the section 'Scenarios that may cause links to not work as expected.'
328440 Description of link management and storage in Excel