I was looking for a setting to do exactly that...update upon opening without any prompt.
I found the setting under the Excel Option/Trust Center Settings/External Content.
Here there are security settings for how workbook links are updated.