Aug 20 2020 08:42 AM - edited Aug 20 2020 06:18 PM
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.