Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Apr 2007
    Location
    Bloomington, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lost Hyperlinks (2003)

    I have a spreadSheet that has had successful links in the past but the links have been copied and pasted into new or other files. Is it posible to recover these links with out having to recreate each and every Link?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lost Hyperlinks (2003)

    Welcome to Woody's Lounge!

    You write "the links have been copied and pasted". Do you mean the hyperlinks, or the targets that the hyperlinks refer(red) to?

  3. #3
    New Lounger
    Join Date
    Apr 2007
    Location
    Bloomington, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost Hyperlinks (2003)

    Sad to say both . But I think that most have had the Hyperlinks relocated.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lost Hyperlinks (2003)

    If the target files have all been moved to the same location, it might be possible to update the hyperlinks using a global replace within a workbook.
    But if the hyperlinks have been scattered over different files, it becomes difficult to do anything about them, unless you already have a pretty good idea where they are.

  5. #5
    New Lounger
    Join Date
    Apr 2007
    Location
    Bloomington, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost Hyperlinks (2003)

    The targets are still in the same folders The folders have been moved to a different location. The targets are in their original folders It's just that the folders have been moved by coping and pasted into new folders.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lost Hyperlinks (2003)

    If all those folders have been moved the same way (for example from C:MyFilesExcel to F:YourFilesArchive), something might be done. However, if they have been moved in different ways, I don't see whay you could do about it.

  7. #7
    New Lounger
    Join Date
    Apr 2007
    Location
    Bloomington, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost Hyperlinks (2003)

    Let me think about this a little bit more and I'll get back to you. I wonder if I can't create a result as a hyperlink by adding it into a formula????

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lost Hyperlinks (2003)

    Excel has a HYPERLINK worksheet function that works like this

    =HYPERLINK("address_to_link_to")

    You can assemble the string argument from fixed and variable parts.

  9. #9
    New Lounger
    Join Date
    Apr 2007
    Location
    Bloomington, Illinois, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost Hyperlinks (2003)

    Thanks I'll try it and let you know how I came out.
    Thanks again
    Danny

Posting Permissions

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