Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / February 2007

Tip: Looking for answers? Try searching our database.

If I PDF a spreadsheet the Links don't work there - help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ERK - 19 Feb 2007 15:30 GMT
I have created a PDF from an Excel spreadsheet.
All the cells on one column on the spreadsheet have links to data on a
website. The links are not transferred to the PDF file.

I know how to place the links on the PDF file:
Tools > Advanced Editing > LinkTool
Then open up a rectangle on the required cells in the PDF and place the link.
BUT, if I make changes to the spreadsheet, then I have to re-create all the
links again in the new PDF file.

What is the procedure to place the links in the cells of the spreasheet such
that they are active in the generated PDF file from the spreadsheet?

Thanks
Erich
David McRitchie - 20 Feb 2007 16:39 GMT
Hi Erich,
Are they working hyperlinks to external files in your Excel file.

Are they  hyperlinks known to Excel  (ctrl+k), or
are they  HYPERLINK Worksheet Formulas.

If HYPERLINK Worksheet Formulas do they involve
concatenation.

Do you get a hyperlink in the PDF that you have to correct,
if so what did it look like,  or  does it appear as plain text
with the descriptive name only.

I expect that you might need to use  http://www.ibm.com
and not  www.ibm.com

I take it that if you are editing PDF files that you are quite possibly
actually using  Adobe Acrobat and the Distiller.   Don't know if it
would make any difference but is your system PC or MAC.

For an Excel newsgroup I think  excel.misc   would have been
a better choice,  but I see why chose this group.  The main
thing for now is to fill in the missing
information as to what software you are using -- what is generating
the PDF, and what do you have in the cells.  There must be nothing
but the hyperllink in a cell.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> I have created a PDF from an Excel spreadsheet.
> All the cells on one column on the spreadsheet have links to data on a
[quoted text clipped - 11 lines]
> Thanks
> Erich
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.