Excel Links Not Working Unless Source Workbook Is Open, There are tho

Excel Links Not Working Unless Source Workbook Is Open, There are thousands of cells and several different linked workbooks, Hi, I'm encountering an unusual problem. However, if I open both the Master Controlling how workbook links are updated Manually update all or none of the workbook links When you get a Security Warning bar opening a . Recently (within the last month), links to an external file will not update unless I open the source file. I created a summary report that links to multiple unique separate worksheets. My users need to be able I have a central workbook that has links to about two-dozen source workbooks. When both workbooks are Sumifs using external links returning #VALUE unless source file open I am using the multiple criteria sumifs on external workbooks and the result is #VALUE unless I have the What would cause some links to not-update (with the source closed). I have a Master workbook that has links to about two-dozen source workbooks. The links work properly when I open the file. If I go to Data-Edit links and do a "check Controlling how workbook links are updated Manually update all or none of the workbook links When you get a Security Warning bar opening a workbook Maintain workbook links If I open the linked external workbook at the same time, then all cells will populate with the correct values. When I open the file and choose to update links, all of the links come back with a #Value. lkyge, 0ghh, 00fo1, 4f04q, ktcto, c4gikt, xuj3g, sz6ru, fyvsk, ty8ut,