Is there any way of keeping a hyperlink active when I've PDF'd an Excel document?
It works fine if I type out the whole link
http://www.blahblah...
But if I have some text in a cell and make the text a hyperlink it gets lost when I create a PDF
Hyperlinks
2008-08-06 07:19:43
My Product Information:
Acrobat Standard 8.0, Windows
Acrobat Standard 8.0, Windows
2008-08-07 14:34:25
#2
I may be misinterpreting the sense of your post; however, you ought to be able to output a PDF from Excel with both the text and the link.
The screenshoots and a link to the output PDF with the text/link are below. This particular output PDF comes from Excel in Office 2000 and Acrobat 8 3D on an XP box. Duplicated it on Excel in Office 2007 and Acrobat 8 Professional on a VISTA box. ~hth
(1) Starting in Excel
[url=http://img403.imageshack.us/my.php?image=jshurss01cz4.png][img]http://img403.imageshack.us/img403/7377/jshurss01cz4.th.png[/img][/url]
(2) Getting to the Adobe PDFMaker dialog
[url=http://img507.imageshack.us/my.php?image=jshurss02tk5.png][img]http://img507.imageshack.us/img507/9286/jshurss02tk5.th.png[/img][/url]
(3) At the Adobe PDFMaker dialog
[url=http://img403.imageshack.us/my.php?image=jshurss03jb6.png][img]http://img403.imageshack.us/img403/7679/jshurss03jb6.th.png[/img][/url]
(4) Back to Excel. Right click to get the context menu for selection of Hyperlink
[url=http://img46.imageshack.us/my.php?image=jshurss04vz5.png][img]http://img46.imageshack.us/img46/1082/jshurss04vz5.th.png[/img][/url]
(5) Excel's Insert Hyperlink dialog
[url=http://img523.imageshack.us/my.php?image=jshurss05pe2.png][img]http://img523.imageshack.us/img523/4596/jshurss05pe2.th.png[/img][/url]
(6) Hyperlink inserted (text in cell goes blue with underline)
[url=http://img46.imageshack.us/my.php?image=jshurss06kl8.png][img]http://img46.imageshack.us/img46/4470/jshurss06kl8.th.png[/img][/url]
(7) Converting to PDF
[url=http://img369.imageshack.us/my.php?image=jshurss07tb5.png][img]http://img369.imageshack.us/img369/5481/jshurss07tb5.th.png[/img][/url]
(8) The output PDF with text and hyperlink
[url=http://img523.imageshack.us/my.php?image=jshurss08fy7.png][img]http://img523.imageshack.us/img523/4092/jshurss08fy7.th.png[/img][/url]
To confirm the link functions
[url]http://daka630.tripod.com/pdf/Book1.pdf[/url]
Be well...
The screenshoots and a link to the output PDF with the text/link are below. This particular output PDF comes from Excel in Office 2000 and Acrobat 8 3D on an XP box. Duplicated it on Excel in Office 2007 and Acrobat 8 Professional on a VISTA box. ~hth
(1) Starting in Excel
[url=http://img403.imageshack.us/my.php?image=jshurss01cz4.png][img]http://img403.imageshack.us/img403/7377/jshurss01cz4.th.png[/img][/url]
(2) Getting to the Adobe PDFMaker dialog
[url=http://img507.imageshack.us/my.php?image=jshurss02tk5.png][img]http://img507.imageshack.us/img507/9286/jshurss02tk5.th.png[/img][/url]
(3) At the Adobe PDFMaker dialog
[url=http://img403.imageshack.us/my.php?image=jshurss03jb6.png][img]http://img403.imageshack.us/img403/7679/jshurss03jb6.th.png[/img][/url]
(4) Back to Excel. Right click to get the context menu for selection of Hyperlink
[url=http://img46.imageshack.us/my.php?image=jshurss04vz5.png][img]http://img46.imageshack.us/img46/1082/jshurss04vz5.th.png[/img][/url]
(5) Excel's Insert Hyperlink dialog
[url=http://img523.imageshack.us/my.php?image=jshurss05pe2.png][img]http://img523.imageshack.us/img523/4596/jshurss05pe2.th.png[/img][/url]
(6) Hyperlink inserted (text in cell goes blue with underline)
[url=http://img46.imageshack.us/my.php?image=jshurss06kl8.png][img]http://img46.imageshack.us/img46/4470/jshurss06kl8.th.png[/img][/url]
(7) Converting to PDF
[url=http://img369.imageshack.us/my.php?image=jshurss07tb5.png][img]http://img369.imageshack.us/img369/5481/jshurss07tb5.th.png[/img][/url]
(8) The output PDF with text and hyperlink
[url=http://img523.imageshack.us/my.php?image=jshurss08fy7.png][img]http://img523.imageshack.us/img523/4092/jshurss08fy7.th.png[/img][/url]
To confirm the link functions
[url]http://daka630.tripod.com/pdf/Book1.pdf[/url]
Be well...
What version of Excel are you using? Just to clarify, are you selecting a cell (with existing text) in Excel and then creating hyperlink to a whole link (i.e., www.adobe.com)?
Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.