I have a spreadsheet that is linked via ODBC to a MAS90 data table. I've specified in the connection properties to refresh the spreadsheet upon opening the file. However, below the ribbon I see the following: "Security Warning. Data connections have been disabled." When I open Options, the data connections are always blocked, requiring me to change the setting to "Enable this content." When I do this it then begins the data refresh.

Authentication has been set to "Windows Authentication." However, to refresh the users are asked to authenticate using the credentials for MAS90.

How can I set the "Enable this content" as the default setting?

Thanks.

Joe