• 2 Parter on Links (Excel 2000 SR-1)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » 2 Parter on Links (Excel 2000 SR-1)

    Author
    Topic
    WSBillSutterfield
    AskWoody Lounger
    June 12, 2003 at 3:27 pm #388950

    I’ve got a workbook with several paste links and vlookup formulas to a series of other workbooks (65 in all). Somehow all of the links and formulas are now pointing to another folder other than the one the files are in.
    1. How can this happen? 2. Besides copy and paste to replace the foler in the formlas, is there a quicker way. I tried ‘Edit Replace’ and it did not work.
    The new folder name is long and was truncated in the formulas.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSStats
      AskWoody Lounger
      June 12, 2003 at 3:32 pm #685197

      Try pressing Edit…Links…Change Source and then pointing to the correct source.

      Good Luck

      Reply | Quote
      • WSBillSutterfield
        AskWoody Lounger
        June 12, 2003 at 4:28 pm #685237

        Thanks for the reply. There are about 65 links.. is there a way to automate this process?
        Any idea on how this could happen in the first place?

        Reply | Quote
        • WSsdckapr
          AskWoody Lounger
          June 12, 2003 at 4:52 pm #685246

          Edit and replace will work in formulas. What didn’t work?

          You can also do changes in VB of formulas by working with a cells “formula” property.
          Hyperlinks (if any) can be changed by working with the Hyperlink object.

          Some causes might be saving a linked file to a new location, while other file is open. Moving the files that are linked, in hyperlinks having a relative reference and then moving the “calling” file.

          Steve

          Reply | Quote
    Viewing 0 reply threads
    Reply To: 2 Parter on Links (Excel 2000 SR-1)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.