Results 1 to 8 of 8

Thread: Excel spontaneously changes reference to linked workbook
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2012
    Posts
    30
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Excel spontaneously changes reference to linked workbook

    I have a cell in a worksheet which is linked to a cell in another workbook. In theory the link should update when I open the first workshheet, however the linking formula has changed itself to c:\Users\Michael\AppData\Roaming|Microsoft\Excel\file name and cell reference. It is supposed to link directly to a cell in a workbook in my D: drive and ,because it doesn't, the result in the cell is outdated. I have manually changed the formula to directly link to the appropriate cell but Excel simply changes it back. Help!

  2. #2
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,679
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Excel spontaneously changes reference to linked workbook

    Cross psoted here: https://www.excelforum.com/excel-for...workbooks.html

    Per moderator reply at Excel Forum - we too require that you include links to cross-posts. This is so that possible contributors can see what suggestions have already been offered.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  3. #3
    New Member
    Join Date
    Jun 2012
    Posts
    30
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel spontaneously changes reference to linked workbook


  4. #4
    New Member
    Join Date
    Jun 2012
    Posts
    30
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel spontaneously changes reference to linked workbook

    Afte trying again to link spreadsheets I have finally been successful (though I don't know why).

  5. #5
    New Member
    Join Date
    Jun 2012
    Posts
    30
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel spontaneously changes reference to linked workbook

    No, I haven't been successful. The linking formula has changed itself again to c:\Users\Michael\AppData\Roaming|Microsoft\Excel\file name and cell reference. It is supposed to link directly to a cell in a workbook in my D: drive

  6. #6
    New Member
    Join Date
    Jun 2012
    Posts
    30
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel spontaneously changes reference to linked workbook

    I gather that nobody has an explanation for this phenomenon. My latest idea is to change the linking formulas back to what they are supposed to be (see earlier posts) then password protect the worksheet. Maybe this will stop Excel from changing the formulas.

  7. #7
    New Member
    Join Date
    Jun 2012
    Posts
    30
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel spontaneously changes reference to linked workbook

    My last attempt to fix the problem failed.

  8. #8
    New Member
    Join Date
    Jun 2012
    Posts
    30
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel spontaneously changes reference to linked workbook

    An update. In an attempt to solve my problem I created a macro which recreates the two links each time it is run. While washing up this morning a possible reason for the problem popped into my head. When setting up the links I have always opened the second workbook by selecting it from the list of recently opened workbooks which appear when I click on Files Open. It occurred to me that Excel might be confused if, days later, it didn't find the desired workbooks in the recently opened files list. As well as the aforementioned macros, I have now linked to the other workbooks by selecting them directly from My Computer. I will see which of the methods work (if either does).

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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