Automatic updating of links in excel
It is possible to accidentally create a link by moving or copying a range, worksheet, or chart between workbooks.
You can answer the startup prompt in a consistent way, and avoid seeing the startup prompt for this workbook.
In Excel, we may create some external links from other workbooks.
In this case, when we open the workbook which contains some links each time, we will get the following screenshot warning.
Visit Stack Exchange How do I enable automatic updates of links for all users, even on other PCs? Click to select the following options, as appropriate for your situation: Prompt user about Data Connections Prompt user on automatic update for Workbook Links Click OK to close the Trust Center dialog box.
I have more than 20 excel sheets that are all linked and need to update.