I am using your Acrobat Pro XII trial version, I am running Excel 2016 for PC. I have hyperlinks in my excel form and when I convert it to PDF they do not transfer over. I have tried "Save as" a PDF and also "Print", save as PDF, convert the Excel file to PDF using Adobe PDF maker. none will work.
Thank you. That really works!
Both options you've used ("Print to PDF" and "Save as PDF") will not bring over the links to the PDF document. When you look at the combination of Acrobat and MS Word, you have at least three different ways to convert to PDF: Word comes with it's own PDF generator that is available even when Acrobat is not installed. Once you install Acrobat, you have two more methods: You can print to the "Adobe PDF" printer, and you can use the "PDF Maker" macro that installs a toolbar or a ribbon in your MS Office application. Printing to PDF will always strip out any interactive content (and more), only the PDF Maker will give you a high quality PDF file. Follow Tariq's instructions to verify that the setting is correctly selected, and then use the "Create PDF" on the Acrobat toolbar to actually generate the PDF output file.
FYI - Per one of my company's IT contract people, this is a known issue with Excel 2016/365 and is most likely Microsoft's problem to fix. (He tested for this problem on other PDF maker software and found the same problem.)
Unfortunately, I was also told that Microsoft is NOT ACCEPTING BUG REPORTS for Excel 2016/365 at this time, so we are stuck trying to work around it.
For me, this results in me still using Excel 2007 when I need hyperlinks, which to be honest SUCKS...but it's not Adobe's issue.
If anyone has further information it would be great to hear it here at some point.
Thanks for the reply and the workaround. That helps !
Just had a reaction from Adobe
Could you try converting excel to pdf using a web browser at this link: https://cloud.acrobat.com/convertpdf and check if internal links work fine.
That works! So it seems that it is not an Excel problem.
Uploading my excel workbook did NOT fix my broken links. Every solution presented here did not fix the broken links. I have one link working out of the 30 on my TOC page. They were all created manually using insert hyperklink, and they all work in the excel document. Definitely an ADOBE issue.
I had this issue and it took forever to figure out a workaround but this worked for me:
The links will work using this method.
This did not work for me. I havd one working link and that broke after this process. Aslo, what if you only want some of the worksheets and not all.?
Hi, have the same problem like reported yet by several peoples here.
Adobe is very bold: NO solution! Issue caused by ADOBE is shown: working on old Version of Acrobat DC pro 2015.016.20045 - NOT working on current Version 2018.011.2005. In both cases identical versions of Excel and identical input xls-file have been used.
Adobde SUPPORT chat was CANCLED without offering any solution by Adobe!
Citation in German:
Es liegt nicht in meiner Absicht Sie zu verärgern. Ich kann Ihnen hierbei allerdings keine Lösung anbieten, da die Quelle der PDF Excel ist. Excel gehört zu Microsoft und kann daher auch nur von Microsoft supportet werden. Da wir uns hier leider im Kreis drehen, werde ich den Chat jetzt beenden. Ich bitte um Ihr Verständnis und wünsche Ihnen noch einen angenehmen Tag.
STRANGE and outrageous reaction by ADOBE
I am incredibly sorry for the inconvenience you had and the experience with the chat support. The issue is already reported to the development team and they are working on a solution/workaround, however, the delay is due to the dependency we have on Microsoft.
Would you mind sharing few details so that we can assist you in a better manner:
Thanks for your time and patience thus far.
is there a official process are working instruction how to tackle this problem? I have a large document with about 80 tabs which are linked to an index with hyperlinks. Once I export this to Adobe Pro 8 it doesn't work.
I could share a test document with only one tab which is edited in MS Excel 365.
Would you be able to assist me on that?
Same question here... external hyperlinks work fine, internal document navigation doesn't works.
Tried the work around with export to xps/pdf but didn't worked...
We found a solution / workaround here. UNchecking this box fixed the issue of no internal links working after an MS Office Update. Now our spreadsheets link again to the pages/tabs.
Could you please share your solution once more? It seems that I can't open the .PNG file.
Looking forward to your answer.
In Acrobat PDFmaker settings, uncheck the box under Application Settings, that says Enable Accessibility and Reflow with tagged Adobe PDF.
This did not work.
Thank you Leonard, this worked for me!
FYI - I wanted to say that this solution also worked for me (unchecking the "Enable Accessibility and Reflow with tagged Adobe PDF" box in the Acrobat Preferences tab in excel). One thing that I did figure out additionally that I thought may prove helpful for some others: if you have used "Insert Links" to create your links in excel, and they are linking to a specific cell in excel, make sure the cell you are linking to falls within the Print Area of your Page Layout.
In my case, I found that my link wasn't working simply because it was linking to cell "A1" of another worksheet, but I did not have cell "A1" of that sheet in my print area. It was out of my own sheer curiosity that I tried expanding the print area, and voila! The link began working.
So long story short: make sure your in-workbook links are linking to cells that also fall within the print area that will be captured when converting to PDF.
Hope this helps!
All great ideas, but none worked for me - and i tried them all to date. My links (websites and documents) are brought in using the hyperlink function. All the actual URLs live on one tab and are brought in onto another sheet via formulas. I have various sheets with different parameters that lookup (index) the multiple lists of URLs. The links in excel work perfectly. However, to PDF, all links go away. Help please!
If you are lucky enough to be using Excel on a Mac not a PC, then the chances are you have the (free) spreadsheet program Numbers too, if not download from the App Store.
Apple know that you probably want links to work when you export a PDF, Numbers can also open Excel files, so steps are as follows:
Sorry, I know that is of no help to Windows users, I'm unfortunate enough to have to use Windows for most of my work, but if you've got a Mac, its easy this way!
Hi. Im hoping someone can assist. I am trying to create a hyperlink in an excel document. When creating the link by inserting a hyperlink, I do not have the option of choosing any PDF documents for some reason. I can view all other file types but the PDF documents dont even show in the folder. Any advice?
I created my hyperlinks using =Hyperlink(,). I did this because I want the hyperlink to have text that can be pulled from a column and link that can be pulled from another column. This will allow the updating of the names and links from a master sheet routinely without need to go into all of the sheets that pull the same data. I can't get (Insert > Hyperlink) to pull the data from my existing columns. Am I missing something? Is there a way to use (Insert>Hyperlink) to pull from existing columns?
it has been 4 years since this issue first arose. It continues to be a problem. People using the hyperlink function and then converting excel sheets to pdf lose their hyperlinks. is there a solution being worked on, or an efficient work-around?
I have over 100 sheets with one tab as the source to a huge list of URLs that the sheets populate from in accordance to specific parameters. Once converted to pdf, not one single link on the sheets stick.
There has to be a better way than to manually add them all back in Acrobat using the link tool.
I had a similar problem. I wanted to make a Phone Directory for work which was loaded up to Microsoft TEAMS. I searched everywhere. I was stuck with uploading an Excel file. It worked but I wasn't happy with it.
Then through a lot of trial and error I found in Excel I go to "Page Layout" and select "Print Area". I then save the document and select Copy. The go to Word and Paste it. From there I can adjust the Custom page size to fit and I even changed the Paper colour to match the Original Excel file so I don't see the white areas at the bottom. It now looks and operates just like an APP, so good. Now to use the Phone directory the other staff only need to click on the name and the dialer opens up on their phone and they're on their way! I'm now making a contact list for all the other departments.
So to summerise, Excel- copy your work- paste to word, then save as a PDF.
Links exported from Excel to a PDF are suboptimal in Adobe Acrobat DC if the link is in a merged cell. Merged cell links may not work or only work in one area and not others where the text is or is not. Be sure your link is in a unique cell for best results. Using PC, Excel 2016.