How do I enable automatic updates of links for all users, even on other PCs?
I have more than 20 excel sheets that are all linked and need to update.
The problem is that sometimes users forget to click enable automatic update of links. How do I get this to be automatic on all PCs?
Best Answer
Check out this KB article method 4:
Method 4:
You cannot and should not have objects or processes managed by the trust center automatically do anything. This is setting a bad precedent. Instead, you should set the workbooks to prompt the users to update every time they open the workbook. If the users are prompted, they will be reminded to update the links.
Additionally, you can take a look at this KB article