If you haven't already found an answer...

V

VICKI NAPIER

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Prompt user on automatic updates for Workbook Links 0
How to enable "enable automatic update" security setting by VB cod 0
User is not prompted to update links when opening spreadsheet 2
Trust Center settings via GPO 0
excel found unreadable content' error is coming while opening xlsx file 0
'excel found unreadable content' error is coming while opening xlsx file 0
Hide Message Bar 0

Top