We have an issue that just popped up with exporting an Excel workbook with Internal and External links to a PDF. The Internal links all get removed, but the External links remain int he PDF.
We have the latest version of Acrobat DC and Office365. Windows 7 Enterprise 64bit.
I've seen a few discussions on this over the past year, with no real solution. And it was working for us a few weeks ago, so I am guessing either an Adobe or Office365 update broke the functionality.
We apologize for the inconvenience caused, as per the description above, the internal links in the PDF are not working after exported from Excel, is that correct?
Please navigate to ACROBAT ribbon in Excel and choose Preferences, under the Settings tab, make sure "Add Links" is checked.
Also, in the Acrobat's Preferences from Edit>Preferences>Convert to PDF>Highlight Microsoft Office Excel>Edit Settings>In Adobe PDF settings for supporting documents window, check the box for "Add links to Adobe PDF file" and click OK.
After making these changes/settings, Close Acrobat and try exporting the Excel file to PDF or try creating the PDF from Acrobat itself from File menu>Create>PDF from a file and see if the internal links are working or not.
You can also refer and try the suggestions from the following Adobe discussions Excel hyperlinks not working when converted to PDF
If the issue persists, please share the following details:
Let us know how it goes and share your findings.
Thank you for the quick response.
Add Links is checked.
I will look at the other option you mentioned right now, thanks!
Let us know how it goes and share your findings. If possible, please share a sample file so that we can test it at our end as well. To share the file, please use Adobe Send feature, upload the file, share the link to files via private message only, How Do I Send Private Message
Neither of the options worked to resolve the issue. I've sent you a link to the file in a private message.
Thanks again for your help and quick response!
Thank you for sharing the details, we are looking in the file and will share an update shortly. Thanks for your time and patience.
Any update on this yet?
How utterly frustrating.
Hunting through google and Adobe and no answer for what should be a basic function, and in fact in Adobe XI it was.
Hours wasted inserting links only to have the pdf rendered useless. Disheartening.
The selection for Microsoft office Excel does not appear in the list of "convert to PDF" preferences.
It turns out my version of 365 was corrupt.
After reinstalling, the PDF converter worked.
Thanks Bob. We will try that and let you know how it goes.
After the reload, the Create PDF button under the ACROBAT tab, showed up.
Then use the option that's appropriate, and the links work.
So I don't have OpenOffice; am using MS Excel 365 ProPlus in Windows. I just applied updates, and it's still not working.
Also, in Acrobat (Dc Pro) in the covert to PDF preferences, none of the MS Office apps appear in the list of formats.
This is really frustrating.
Update-- links work if the link is to another file, but not to another worksheet in the workbook.
Not sure what you're trying to accomplish.
A link within the workbook is done via the Insert Hyperlink and selecting "Place in this Document"
I understand. When i link to another place in this document it does not convert. The link is dead in Acrobat, but as a test I tried linking to a file, and that link worked. That's not what I want to accomplish, but it shows the problem is not with all links. Just the internal ones.
No luck yet.
Anand, any luck on your end?
Internal links still do not convert.
FYI, we just tried using Nuance's PDF Pro and it worked.
Sorry for the delayed response and inconvenience caused. The issue is intermittent with specific to the environment and on the dependency of Acrobat on Microsoft, we have already reported this to the development team and a fix has been identified and undergoing internal validations. We will share an update as soon as it is publically available.
Thanks for your time and patience thus far.
After endless not helpful chat discussion on the so called SUPPORT chat (now I understand that the definition of support @Adobe is different to the common one and mine) I saw this entry.
Same problem in my comstellation. Due to the fact, that it could be clearly shown, that ist issue is caused ONLY by Acrobat I will force you and your colleagues to provide solution immediately.
Facts based on
1) ONE Excel-file with INTERNAL links done on one computer
2) Conversion done with Acrobat DC pro in Version 2015.016.20045 --> conversion done including internal links working correct in pdf
3) Conversion done with Acrobat DC pro in Version 2018.011.20055 (latest Version!) --> conversion done, BUT internal links NOT working in pdf
it's clear: responsible --> Adobe
First entry here says "I've seen a few discussions on this over the past year" makes me not happy.
Adobe should provide solution within a a customer acceptabel time ....
Please go ahead.
Currently Acrobat ist not capaable to fullfil my demands due to updates somewhen done between Version 2015.016.20045 and 2018.011.20055 (latest version!).
I won't pay anymore for a product with lost functionality.
This is now mare than 1 year ago and it still does not work.
When will the fix be implemented?
I am sorry for the inconvenience caused and for the delayed response. I will gather more information around this and will share an update as soon as possible.
Thanks for your time and patience thus far.
Any update???? Its now November 2019 and I'm still dealing with this.
Open the Excel file in OpenOffice and export it as PDF.
I work as an end-user IT support at Škoda Auto and I am currently dealing with the same problem as everyone else.
Our user who used on the old MS Office 2010 Standart with Adobe Acrobat 2010 and was always successful when converting from MS Excel to PDF. After getting a new machine with Office 2016 and Adobe Acrobat 2017, however, the ability to export functional links in pdf files was lost.
That's why I started testing and contacted Microsoft Support.
Personally, I tested MS Office 2010, 2013, 2016, and I can say that link conversion from 2013 above does not work. I've tried all the recommended settings for a successful conversion. I can say that I have tested all of these versions separately and then with the available versions of Adobe Acrobat (2010, 2011, 2015, 2017). Unfortunatelly, except for the first election.
The MS Office 2010 version is the only one that works reliably with any Adobe Acrobat version.
However, support for MS Office 2010 is coming to an end soon. That is why we are looking for a solution.
This whole matter has several specifics. Microsoft has admitted that even if it allows you to save files to PDF, it is just an "additional feature" and knows the problem. Additionally, he admitted that even MS Office 365 does not. He further noted that modifying and interfering with the problem-solving program would probably bring more problems than good.
The conclusion of this communication and the recommendation of Microsoft Support is that MS Office has never been functional for this transfer. And he referred me to Adobe, whose Acrobat sw is used in our country. I totally disappointed. I expected that if this feature is available, it will work 100%.
If anyone knew about a solution to this problem, I would be very happy to share it.
The way I use some other third party swap does not come smart, but I will take my gratitude for any tip.