Hello,
I have a spreadsheet that uses DDE and macros. I am trying to automate opening the file to ensure it is always running i.e. need to reopen the file if it closes for any reason; but these error/security warning messages are getting in the way of having the file actively working. When opening the spreadsheet I get the following security warning:
"This workbook contains links to external data sources that use DDE (Dynamic Data Exchange) that may be unsafe and have been disabled. See File > Options > Trust Center for DDE configuration options"
This is followed by the warning:
"We can't update some of the links in your workbook right now. You can continue without updating their values, or edit the links you think are wrong."
I am assuming this is related to the first warning, because once the spreadsheet is working there seem to be no issues with the links.
I have tried the following which have not eliminated the DDE error message:
- changing the "security settings for Data Connections" to "Enable all Data Connections (not recommended)"
- adding the file location as a trusted location
Ideally I would like to alter the settings to eliminate these messages, without compromising the security of my PC. Otherwise is there a way to make these pop-ups automatically disappear as the file opens?
On a related note, my current macro setting is "Enable all macros" - is there a safer setting to use (or a work around) - which still avoids all the popups? This is the main spreadsheet I use day in day out that contains macros.
Thanks for your help.
I have a spreadsheet that uses DDE and macros. I am trying to automate opening the file to ensure it is always running i.e. need to reopen the file if it closes for any reason; but these error/security warning messages are getting in the way of having the file actively working. When opening the spreadsheet I get the following security warning:
"This workbook contains links to external data sources that use DDE (Dynamic Data Exchange) that may be unsafe and have been disabled. See File > Options > Trust Center for DDE configuration options"
This is followed by the warning:
"We can't update some of the links in your workbook right now. You can continue without updating their values, or edit the links you think are wrong."
I am assuming this is related to the first warning, because once the spreadsheet is working there seem to be no issues with the links.
I have tried the following which have not eliminated the DDE error message:
- changing the "security settings for Data Connections" to "Enable all Data Connections (not recommended)"
- adding the file location as a trusted location
Ideally I would like to alter the settings to eliminate these messages, without compromising the security of my PC. Otherwise is there a way to make these pop-ups automatically disappear as the file opens?
On a related note, my current macro setting is "Enable all macros" - is there a safer setting to use (or a work around) - which still avoids all the popups? This is the main spreadsheet I use day in day out that contains macros.
Thanks for your help.