Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2 Parter on Links (Excel 2000 SR-1)

    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.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 Parter on Links (Excel 2000 SR-1)

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

    Good Luck

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 Parter on Links (Excel 2000 SR-1)

    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?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: 2 Parter on Links (Excel 2000 SR-1)

    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

Posting Permissions

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