VBA Update Links

[Chris_010101]

I've created and stored a workbook on a teams group for a number of users which contains formulae which link to another workbook I have saved separately, on a different teams group.

I have tried to set the workbook to automatically update links but when other users, who are not that experienced with Excel open the workbook, they are often presented with a ribbon warning saying excel prevented automatic updating of links. Sometimes, they aren't spotting this and claiming the spreadsheet wont work, which is tedious and frustrating having to share screen and show people where to click....!

Is there a piece of VBA code which can bypass this annoying warning message and force update links for all users as soon as the workbook is opened?

 

[Kerryx]

Did you try
How to control the startup message about updating linked workbooks in Excel

 

[Chris_010101]

Did you try
How to control the startup message about updating linked workbooks in Excel

Those instructions are for controlling the setting for each individual user.

If I apply these settings, the same settings won’t be applied to another user.

 

[Josu]

Same question here...