Excel 2016/365 Ignore DDE being... ignored?

Scotster

Board Regular
Joined
May 29, 2017
Messages
54
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
One of the most useful features of Excel for me is ignoring DDE links. It allows me to easily create multiple separate instances of excel that other users won't inadvertently try and open up their spreadsheets in (When running userforms etc).


For some reason, I cannot get it to work properly with 2016 though. I can open Excel, tick "Ignore DDE" in the advanced settings, close Excel and then open a file without any issue. It's as if the selected option is doing absolutely nothing. I've checked and double checked that the option is selected.
Is anyone else noticing this behaviour?


Office 365, Excel 2016 x32 on Windows 10 x64.


Many thanks.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,214,915
Messages
6,122,217
Members
449,074
Latest member
cancansova

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