Excel: "Error: Source Not Found" RRS feed

  • Question

  • Hello,

    When a formula is linked to the external spreadsheet, I get an error message "Error: Source not Found". I have to manually open the source each time I have to work on this file. Both files are under same format, under same network. Surprising my co-worker is not facing a similar problem.  I have checked under my formulas option, and I see that I have selected "Automatic" under "Work Calculation".

    Please let me know what should I do.



    • Edited by Huka_999 Thursday, May 26, 2016 4:33 PM
    Thursday, May 26, 2016 4:32 PM


  • Hi Huka,

    Based on your description, did you get the problem as shown in the following picture:

    Did links still update in your environment? Did you get any wrong values?

    In my opinion there may be some problems in the source, #REF! errors, missing links to macros, or links in the source that are themselves broken.

    First please check the data source in your environment.

    Then you can also refer to this KB article to get more information:


    Any updates please let me know and I'm glad to help you.


    Emi Zhang
    TechNet Community Support

    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Friday, May 27, 2016 9:02 AM