Closed Thread
Results 1 to 2 of 2

Updating Links (paths to other workbooks) - Bizarre Behaviour Problems!

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    UK
    MS-Off Ver
    Office 10
    Posts
    25

    Updating Links (paths to other workbooks) - Bizarre Behaviour Problems!

    Hi folks,

    I thought I was familar with how to update the paths for links to other workbooks (when changing the file location of the two (or more) interconnected workbooks) - but I've experienced some bizarre behaviour. Can anyone help?...


    Ordinarily, when I open a workbook with links to another workbook (whose file location I've recently changed), I get an Excel warning message asking if I want to update the data (I do), and then another warning message saying Excel the workbook has links that cannot be automatically updated (because the source workbook has changed location), and asking if I want to edit the links (i.e. change/specify the paths to the source workbooks). I do.

    Here's where it gets strange. When I select 'Change Source...' and navigate to the first source file - instead of 'accepting' this and changing the source's status to 'ok', it immediately pops up another file selector window asking for the second source file. Then the third. etc. then it cycles back to the first or second source file path again. This happens relentlessly!

    By a combination of canceling and/or 'updating values' and then going back to update other file paths Ive eventually got it all correctly linked again, **but I've no real idea of what I was doing or why excel seemed to be cyclically asking me for the same path details**.

    As an example of one of the wierd states I got the 'Edit Links' dialogue box in, I include the attached screenshot...
    It got worse than this, but even here you can see that excel seems confused about the link status of particular files (workbooks). A single workbook (e.g. Class1_WiderCurriculum.xlxs is listed twice, once where its status is 'ok', and once where it is 'Error:source not found').



    Finally, I've read that such paths are normally stored 'relative' (even if displayed within cells as absolute paths), and wondered whether, in order to avoid such problems entirely in futre I could explicitly write link paths within a cell in formats something like '..\PeerDirectory\[Class1_WiderCurriculum.xlxs]!B4' , where I'm trying to specifiy that the path is 'go to the parent directory, then to a Peer Directory, and the file will be there.


    It's the first (relentlessly cycling requests for updated paths) that bugs me the most, but improving my understanding of all the related problems would be amazing. Thanks in anticipation!

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,554

    Re: Updating Links (paths to other workbooks) - Bizarre Behaviour Problems!

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread

    Note that the other thread is in Commercial Services, available to those with a status of Guru or above.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Updating links to new set of Workbooks each month
    By cmbh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2016, 07:48 PM
  2. Replies: 6
    Last Post: 07-16-2014, 04:27 PM
  3. Replies: 5
    Last Post: 04-25-2014, 11:38 AM
  4. Replies: 5
    Last Post: 11-09-2009, 12:16 PM
  5. Problems updating links on protected sheets
    By Gandalf123 in forum Excel General
    Replies: 0
    Last Post: 01-06-2009, 06:50 AM
  6. Updating Links between workbooks
    By Camilla in forum Excel General
    Replies: 2
    Last Post: 05-05-2006, 09:15 AM
  7. problems with links and updating a worksheet in vba
    By neowok in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2005, 05:30 AM

Tags for this Thread

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