Results 1 to 2 of 2

Thread: Excel Loosing External Source Links, Have to Relink Every Time it Opens

  1. #1
    Neophyte Ruth2002's Avatar
    Join Date
    Aug 2019
    Posts
    4
    Articles
    0
    Excel Version
    Excel 365

    Excel Loosing External Source Links, Have to Relink Every Time it Opens



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have two Excel files (Microsoft 365)that were communicating fine one day and then the next day, it prompts me to update links. Other files have also stopped updating links. I also tried on a different computer (still 365) and get the same message.
    I update the links and open the source file and it works fine. I close it and go back in and it prompts me to relink the links again.
    I've selected "Don't display the alert and update links" under the Startup Prompt

    Click image for larger version. 

Name:	link 1.JPG 
Views:	21 
Size:	46.4 KB 
ID:	9551
    Under Trust Center I Selected "Enable all Data Connections and "Enable automatic update for all Workbook Links" and "Enable all Linked Data Types".
    Click image for larger version. 

Name:	link 2.JPG 
Views:	9 
Size:	91.3 KB 
ID:	9552
    I also went into Advanced under Options and selected "Update links to other documents" and deselected "Ask to update automatic links".
    Click image for larger version. 

Name:	link 3.JPG 
Views:	7 
Size:	90.2 KB 
ID:	9553
    I do not know what else to do. It was working fine one day and not the next. As far as I know, there were no updates.
    Any help would be greatly appreciated.


    I have two Excel files (Microsoft 365)that were communicating fine one day and then the next day, it prompts me to update links. Other files have also stopped updating links. I also tried on a different computer (still 365) and get the same message.
    I update the links and open the source file and it works fine. I close it and go back in and it prompts me to relink the links again.
    I've selected "Don't display the alert and update links" under the Startup Prompt

  2. #2
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    52
    Articles
    0
    Excel Version
    1901
    Have either of the files moved from their original location? Sometimes this impacts the original files even after you update.

Tags for this Thread

Posting Permissions

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