However my links still won't export. I've tried the Excel Worksheet as well as the Excel 97-2003 options and neither works. It exports fine to PDF and Word but just not Excel. I am setting the hyperlink via the value field for an HTML text box. I've also tried setting the Navigate To Url property and that doesn't work either. I am trying to convert an excel with internal links(i.e. Links to different places within that same excel) to a pdf. I have gone through the several posts available online in this regard and couldn't seem to find any proper solution for such a conversion. The solutions provided mostly works for the external hyperlinks and not the internal one's.
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!
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.
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.
Excel Formula Not Working
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.
Excel Pdf Links Not Working In Chrome
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.
-->
Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
If you have Skype installed, see Text has incorrect format when using paste in Microsoft Office for more information. The Paste Special option can make the task of pasting text go more smoothly by letting you choose which formatting you want to keep (source or destination) or by stripping all the formatting and just pasting the text. If you are having issues with the Paste Special option, continue on to the resolutions below.
Resolution
To see if the Paste Special option is enabled:
- Go to File > Options > Advanced.
- Under Cut, copy and paste, ensure the Show Paste Options button when content is pasted option is checked.
Note
Excel Pdf Links Not Working On Ipad
Using the Worksheet_SelectionChange event will clear the clipboard, which disables the Paste Special option. To enable the option, you need to set the value of the Application.EnableEvents property to False.
Ensure that all instances of the web browsers that you use are closed and try to use the Paste Special option again. Paste special will not function if your web browser is causing the conflict. Windows Internet Explorer (8-9) do not conflict with the Paste Special option in Excel 2010. Third party Add-ins can cause a variety of issues, one of then being, conflicting with the Paste Special option. To determine if an add-in is causing the issue:
Yahoo Links Not Working
Find the Microsoft Excel icon.
Press and hold the CTRL key and double-click the application shortcut.
Click Yes when a window appears asking if you want to start the application in Safe Mode.
Note
If you have an icon on your desktop, hold the CTRL key and click on the icon. This works with any Microsoft Office product.
If the Paste Special option works in the Safe Mode as follows, enable your Add-ins one by one until you hit that one that is causing the conflict. Leave that one disabled or uninstall it.
Note
For more information, see Adding or Removing Add-ins and Working with Office Safe Modes..
|
Excel Print To Pdf Links Not Working
You can also get help from the Microsoft Community online community, search for more information on Microsoft Support or Windows Help and How To, or learn more about Assisted Support options.