Security Issue: Data Connections Disabled
 

Hello,

I have a problem with some Excel Sheets that always have the following
warning: "Security Warning: Data Connections have been disabled" which block
any attempt to connect to that Excel Sheet (I'm trying to retrieve the data
into SSIS, but that's not the main issue). The thing is I click on "Options"
in front of that warning and set it to enable content and I save the file,
enabling extenal connections for as long as the sheet is open. As soon as I
close the sheet the new setting gets lost and it gets back to blocking the
external connections. Any clues for how to keep data connections enabled?