Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2001
    Melbourne, Victoria, Australia
    Thanked 0 Times in 0 Posts

    Hyperlinks dont work when workbook is emailed (Excel 2007)

    I have created a workbook with HyperLinks to various files which works fine.

    When I email the workbook (and associated files) the hyperlinks still point to the original file location and will not open (as is on a separate PC).

    Is there anyway to "package" the file so that all linked documents are sent together and automatically remain linked so the recipient doesn't have to remap all of the links?

    Thanks in advance for any assistance.

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Dallas, Texas, USA
    Thanked 1 Time in 1 Post

    Re: Hyperlinks dont work when workbook is emailed

    Just thinking out loud...

    If the end-user could ultimately place those included files "anywhere" on their PC, the hyperlinks could not be pre-written to point to them.

    You could put the worksheet and associated files into a zip file, a program like WinZip will allow you to predetermine "default" locations for the files to unzip. As an example, you can choose to send those files to the users desktop, to their My Documents directory, etc, during the unzipping routine. Still, this is not foolproof, the user can make changes during the unzipping process or later move the files, making the hyperlinks point to nowhere...

    Don't misconstrue this as the final word; hopefully someone will chime in and point you in the proper direction.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Hyperlinks dont work when workbook is emailed (Excel 2007)

    If the files are all in the same folder as the workbook, the hyperlinks should still work if the recipient saves all files in the same folder, even if the folder has a different name than the one you used.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts