Hyperlink in Excel work => pdf no hyperlink attached

Hello

I have an excel file with hyperlinks on sheet 2. On sheet 1, I placed in a cell following formula:

Please Login or Register  to view this content.

The part

Please Login or Register  to view this content.

of the formula is a Zapf dingbats character.
When we click on the character in Excel, the application jumps to the URL.
When we create a pdf file of that sheet, Acrobat does NOT recognize an URL. Is there any specialist who can tackle this issue so that we are able to create the pdf and when we click on the character that the requested URL will be opened?

Kind regards

When converting to html:

* Layout is damaged (e.g., rotated text in cells will loose its definition)
* Links in html are working, underline will be added below the charachter =>
* When creating pdf of html => loose again all link functionalities => death links


Any other suggestions?

addendum - Copy.xlsx

here you have

html link is too long, even in point size 1 and a narrow font. Text will be cut-off => link does not work.
So problem 1 is solved about to get the link working. Another NEW problem is about the length of the link. Even with wrap text ON and click on the pdf link results in a cutted weblink.

Ideas to solve this issue? See xls for reference.

excel sheet of post#7: Copy of addendum - Copy_WORKAROUND FOR HELMUT.xlsxCopy of addendum - Copy_WORKAROUND FOR HELMUT.pdf

1. I pasted the link
2. Reduce the font to point size 1
3. Give it a foreground color of white
4. Paste an activeX button
5. I create pdf => result: if you click ON the grey area => nothing.
6. If you click just above the outside border of the activeX => go to an URL who is cutted off

Indeed :s, but big question for me is still: why did it not worked before? If I go with the hand tool in Acrobat professional DC over the button, it seems ok and link works.
In my test, I had to go to the left to of the button and the link was cut-off. When I went over the middle of the button, there was no link at all behind that button.
Did you something changed on settings of the button/link (from my side the wrap text was activated)?

Let's get a new clean try for my side

I tried it on my own with my own software (Excel and acrobat professional dc) to create the pdf. Result: link does not work. Acrobat opens IE but goes to a cut-off weblink:

Untitled-1.png


Link in excel is correct:

Capture.JPG

Do you use another application to create pdf? I use the printer driver installed with Adobe acrobat Professional DC: Adobe PDF

Yes, that's it that trick!
Other small issue is: the activex button disappears for 95%. I only see a very small stroke line at the left, the other part of the box is gone BUT the link works.
Hope if we can finetune this

Copy of Copy of addendum - Copy_WORKAROUND FOR HELMUT.xlsx
Copy of Copy of addendum - Copy_WORKAROUND FOR HELMUT.pdf