Hyperlinks Not Working In Excel 2016

  1. Why Are My Excel Hyperlinks Not Working
  2. Break Link Not Working In Excel 2016
  3. Link In Excel Not Working

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.

Excel Hyperlinks Stopped Working. Excel Details: Why have the hyperlinks in Excel 2013 stopped working.Excel Details: Check your Excel settings to see if the interpretation of a hyperlink value in a cell should be rendered as regular text or if it should be a live hyperlink.Go to Options - Proofing and ensure 'Ignore Internet and file addresses' is checked on. Links not opening in excel.

Not

You would need to correct the hyperlink address to the updated file name so that the file becomes detectable. Follow the steps below to edit the address. Step 1: Copy the address of the new file from the file's explorer. Step 2: Head to Excel. Step 3: Right-click on the hyperlink, and click 'Edit hyperlink' in the menu. If that is not the problem, you may want to turn off an option in Excel that causes the program to check hyperlinks whenever the workbook is saved. (There have been some reports that Excel disables the links a bit too early sometimes, which could be the behavior that Fanie is seeing.).

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.

The other day I needed to create a PDF file. I had written my latest e-book on Secrets of Successful Blogging in MS Word. This ebook contains a lot of very useful links for the reader. Before publishing it, I wanted to convert this MS Word ebook in PDF format. There are several methods available for such a conversion. Now even MS Word has built-in support for PDF printing. So, it should not have been difficult at all for me. But I created the PDF file using a third party plugin of MS Word. PDF file was all fine but a strange problem crept in. Hyperlinks given in the MS Word document were not working in the newly created PDF.

Links (both web URLs and email address links) in PDF were formatted in blue color and underline (the way they were in MS Word) but they were not clickable. It was important for me to make these links in PDF work. So, I asked Google and did a bit of research on it.

I found that this problem was faced by many people. In several forums plugins and online PDF services were suggested as the solution of this problem.

I tried installing a few plugins in MS Word 2007 to be able to print PDF with clickable links. These plugin included word2pdf free version. I also tried online PDF services like pdfonline but no luck! Links in the PDF file still refused to work.

I also tried standalone software like CutePDF, but still, links did not work!

However, thankfully, soon I found a solution!

Hyperlinks Not Working In Excel 2016

If links are not working in your PDF, you should use the Export feature of MS Word 2013 or Save As feature of MS Word 2007. When I exported my ebook as a PDF, I found that all the links in PDF were intact and clickable.

Hyperlinks Not Working In Excel 2016Excel

Open your document in MS Word 2013

Go to File menu and then select Export To option. Then click PDF or XPS. Save the file.

MS Word 2007

Open your document in MS Word 2007

Go to Office Orb button in top-left corner and then select Save As option. Then click PDF or XPS. Save the file.

The message from this small tip is that, you do not need any third-party plugin or online PDF creator to print the PDF file. Just use built-in facility in MS Word and links in PDF will work without any problem.

If you have a document that you created with any version lower than 2007, you can always find a machine with 2007 or 2013 and get a PDF file with perfectly working links.

I hope this was useful information for you. Please feel free to ask if you have any questions on this topic. Thank you for using TechWelkin.