Excel DDE security warnings and macro security settings

mhwolog

New Member
Joined
Sep 28, 2016
Messages
28
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.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Hello, Sorry for the delay.

I tried under Private Sub Workbook_Open() the following two lines:

ActiveWorkbook.EnableConnections
Application.DisplayAlerts = False

and

under Advanced settings>general:
I ticked Ignore other applications that use Dynamic Data Exchange

and under Trust Center>Macro Settings:
I ticked enable all macros

and under Trust Center>External Content:
I ticked Prompt user about data connections
I ticked prompt user on automatic update for Workbook Links
I ticked Prompt user about Linked Data Types
I ticked Enable Dynamic Data Exchange Server Lookup
I ticked Enable Dynamic Data Exchange Server Launch

These were the settings I played with. The problem has been solved (although I don't think I didn't really want to enable all macros). From memory if I altered any of the above settings the problem came back.
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,619
Latest member
Shiv1198

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top