warning source not recalculated

%3CLINGO-SUB%20id%3D%22lingo-sub-1601766%22%20slang%3D%22en-US%22%3Ewarning%20source%20not%20recalculated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601766%22%20slang%3D%22en-US%22%3E%3CP%3EI%20utilize%20a%20destination%20workbook%20with%20many%20source%20workbooks%20linked%20that%20are%20shared%20for%20others%20to%20input%20data.%20This%20is%20stored%20on%20OneDrive.%20Whenever%20I%20open%20the%20destination%20workbook%2C%20I%20update%20as%20prompted%20then%20a%20box%20opens%20for%20edits.%20When%20I%20open%20this%20...%20all%20of%20the%20sources%20that%20have%20been%20opened%20and%20new%20data%20entered%20have%20this%20warning.%20How%20do%20I%20get%20this%20to%20automatically%20update%20the%20links%20without%20having%20to%20manually%20open%20each%20source%20workbook%3F%20All%20workbooks%20are%20currently%20on%20automatic%20calculation%20setting.%20Thanks%20in%20advance%20for%20any%20responses.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1601766%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

I utilize a destination workbook with many source workbooks linked that are shared for others to input data. This is stored on OneDrive. Whenever I open the destination workbook, I update as prompted then a box opens for edits. When I open this ... all of the sources that have been opened and new data entered have this warning. How do I get this to automatically update the links without having to manually open each source workbook? All workbooks are currently on automatic calculation setting. Thanks in advance for any responses. 

 

0 Replies