how to disable Update Links warning in excel2016?

[akika]

Hi,
in excel2016, created a new workbook with macros having URLs. every time I open this workbook I get the message box:
"this workbook contains links to one or more external sources that could be unsafe.
if you trust the links , update them to get the latest data. Otherwise, you can keep working with the data you have."
Update Don't Update Help buttons

when click updatebtn getting
"we can't update some of the links in your workbook right now
You can continue without updating their values or edit the link you think are wrong"

I hv try below but it still prompt to this msg:
Click, Edit Links > Startup Prompt > Don't display the alert and update links
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False


how can i disable this msg when open the wrkbook?
pls help...

 

[Chihiro]

You need to add location/document to trusted space.

Though I'd never recommend it for downloaded file. With exception of internal network and trusted portals.

File -> Options -> Trust Center -> Trust Center Settings

Adjust/add location/document as needed.