+ Reply to Thread
Results 1 to 8 of 8

Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperlinks

  1. #1
    Registered User
    Join Date
    03-30-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    90

    Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperlinks

    Hello, I wonder if anyone can help me.

    I have a excel document full of hyperlinks, and suddenly all hyperlinks have changed from one drive on my computer to another one.

    Is there any way I can change a small sector of the wrong hyperlinks and change it to the correct one (with control f) as there is only one pert of the link that is incorrect...

    Any help greatly appreciated.

    Thank You

    E

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperli

    Try this macro editing the OldString and NewString values appropriately.

    Please Login or Register  to view this content.
    Martin

  3. #3
    Registered User
    Join Date
    03-30-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperli

    How do I input a macro :S

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperli

    ALT F11, Insert Module, Paste in code, Alt F11 back to workbook. View ribbon, macros.

  5. #5
    Registered User
    Join Date
    03-30-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperli

    When I press F11 it takes me to a chart

  6. #6
    Registered User
    Join Date
    03-30-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperli

    OK Sorry. I forgot to press Alt.

    I have now put in the macro and the code, but it makes no difference what so ever.

    Any ideas?

  7. #7
    Registered User
    Join Date
    03-30-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperli

    Will this work if I only want to change one part of the link?

  8. #8
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Urgent: Hyperlinks all changed in Excel, how to cotrol f a sector of the wrong hyperli

    The code replaces the part of the link specified in OldString with the text specified in NewString. Have you actually run the macro?

    If you can supply an example of the old hyperlink and its corresponding new one, I can make the adaptations to the code for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1