Skip navigation
Currently Being Moderated

Hyperlinks from Excel to PDF

Jul 6, 2009 4:05 PM

Hi,

 

I'm using Excel 2003 Pro. In a spreadsheet, I have a list that is distributed to a domain on a weekly basis as a PDF file. The Spreadsheet contains Hyperlinks linking to URL's. I'm using Acrobat 7.0 Standard. When I create the PDF-file from my Excel-sheet all the links disappear...?

 

Is there a way to keep the links from my Excel-sheet in a PDF-file...?

 

 

Thanks in advance

Michael

 

 

PS: Using link tool and edit links directly in PDF is not an option!!

 
Replies
  • Currently Being Moderated
    Jul 6, 2009 6:00 PM   in reply to Leachim Mad

    How are you creating the pdf? If you use the toolbar, it should work to preserve links. If you print to pdf it will not preserve links.

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 7, 2009 1:10 AM   in reply to Leachim Mad

    How about using googledocs? I tried for exporting word 2003 to PDF and all the links are live.

     

    Thus you may upload your spreadsheet then download as PDF.

     

    You may have a try. Good luck!

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 7, 2009 4:15 AM   in reply to Leachim Mad

    When you use the toolbar in Excel to convert to PDF, did you check the options from Excel - Adobe PDF->Change Conversion settings? The options "Enable accessibility..." and "Add links.." should be checked ON (these are ON by default). Please try after setting these 2 options ON and converting to PDF again from Excel->Adobe PDF->Convert to PDF.

    -Amboo

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 22, 2009 5:53 AM   in reply to Leachim Mad

    Have you updated Acrobat to at least 7.05 or greater?

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 6, 2009 2:02 AM   in reply to Leachim Mad

    Exactly the same problem here as well!!!

    I mean, it's just frustrating when the links in Word are kept after the conversion but those in Excel are all gone!!!!

     

    I am using Microsoft Office 2003 and Adobe Acrobat 7.0.8 Standard.

     

    Need URGENT help on this!!!

     

    Many thanks in advance!!!

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 6, 2009 2:28 AM   in reply to Yike Wang

    Can you post a sample document?

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 6, 2009 4:01 AM   in reply to Bernd Alheit

    well, the truth is, it doesnt work in ANY cases!!!

     

    I mean, you can try it out as I did: open a new excel file, write click on it! in the first cell and make a hyperlink to a document or whatsoever.

     

    It works perfectly in Excel but after the conversion, all i got was "click on it!" without any hyperlink!!!

     

    :S

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 6, 2009 6:14 AM   in reply to Yike Wang

    Whoa! I just tested it with Excel 2003 and AA7.1.3 (the latest, not 7.1.0) on XP. I got the same result. The link in the PDF was in appearance only. To confirm the setup, I also did the same process in WORD 2003 and the link works. I don't have a solution, just confirmation as well as a comment regarding the version number.

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 6, 2009 6:46 AM   in reply to Bill@VT

    -.-"

     

    You see?? How absurd that is!!! I mean it works just fine with Word while it totally messes up the hyperlinks in Excel!!!!

     

    Ahhhhhhhhhhhhhhhhhh!!!   >:(

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 6, 2009 3:11 PM   in reply to Yike Wang

    As a follow up, I tried it with Excel 2007 and AA8. The links worked fine. I wonder if this is an issue with PDF Maker or Excel 2003. It is likely a PDF Maker problem, but would not discount Excel entirely. You might want to try an update to OFFICE 2003 (or maybe that is the problem!). I am on Excel  2003 SP3 (11.8307.8221).

     

    As a follow up, I tried it with OFFICE 2000 and AA6. The link worked. Again, it does not help but suggests a problem with AA7 PDF Maker with OFFICE 2003. Bill

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 24, 2009 9:30 AM   in reply to Leachim Mad

    In excel, are you using Insert>Hyperlink or are you using the =HYPERLINK() function in the cell?

     

    I find that using the Adobe pdfmaker within Excel ONLY preserves links if they are defined by Insert>Hyperlink.

     

    Any other users found this?

     

    Its very annoying as I have 700 rows of hyperlinks generated using the HYPERLINK function!! I am not going to redefine them all by using Insert>Hyperlink.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points