These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Hyperlinks flaky from Excel 07 to Adobe Acrobat 9

nadineperry
Registered: Jul 26 2009
Posts: 6

Hi

My links are in an excel cell with wrapped text

PDF result - only links the top line of the hyperlink

Tried different preferences and attempted different forms of the original excel link with no successs.

Please tell me what switch to flip

I know about the "general" check box... its on

TIA

Nadine

My Product Information:
Acrobat Standard 9.1.1, Windows
daka630
Expert
Registered: Mar 1 2007
Posts: 1420
Nadine,
In context of my post to this thread:
[url]http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=20418[/url]

I suspect how a word wrapped URL is dealt with is a function of the source application, the mechanism used for report generation, and (when used) the version of PDFMaker used.

The early PDFMakers were less "robust" than the current one(s).

Report generation schemes that are "in house" (by staff users/ad-hoc programmers or the vendor of the software used) may use a "2.5 & survive" approach to PDF creation in that they may not adequately embrace the identified criteria in the ISO standard or the Adobe PDF References that preceeded the ISO standard.Using Excel 2007 and Acrobat 9 Professional Extended I placed a 75 character URL in a cell having a cell width of 11.
In Excel, I used Cell Format > Alignment > and selected "Wrap text".
< http://www.nrc.gov/reading-rm/doc-collections/cfr/part030/part030-0071.php >With word wrap the URL, in the cell, appeared as:
http://www
.nrc.gov/rea
ding-rm/doc
-collections/
cfr/part030/
part030-0071.php

In the Preferences for the Acrobat PDFMaker I selected "Add Links".
In the General Category of the Acrobat Preference dialog "Create links form URLs" was selected.

The output PDF, from the Excel worksheet, contained a functional weblink where the word wrapped text was.
However, use of the Link tool identified that no link "box" was present over this text.

A second run, with Acrobat's "Create links from URLs" de-selected, resulted in no link associated with the word wrapped text.

So, if Section 508 accessibility is not a consideration, you could use the configuration of the first run to obtain a working weblink in a PDF.
This setup lets you use what Adobe provides, out of the box, for proper PDF creation; which is to say per PDF Reference or, now, per the ISO standard.

Be well...

Be well...

nadineperry
Registered: Jul 26 2009
Posts: 6
omg thank you for this detailed explanation -- I will try it on Monday and let you know how it goes. Once again I sooo appreciate your time !!

Peace
Nadine