Avatar of eemoon
eemoon
 asked on

Why cannot open any excel files after enable "Ignore other application that use Dyanamic Data Exchange (DDE)"

Hi I cannot open multiple excel(2010) instances at the same time. After enabling "Ignore other application that use Dyanamic Data Exchange (DDE)", I can open multiple instance. However, days ago, I suddently could not open all excel files. After disable "Ignore other application that use Dyanamic Data Exchange (DDE)", I can open excel file, but i cannot open multiple excel files at the same time. Anyone can give some idea for this? Thanks

"Ignore other application that use Dyanamic Data Exchange (DDE)" is located at Option ----> Advanced ----> General
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
eemoon

8/22/2022 - Mon
Qlemo

It is not totally clear which problem you try to solve by switching off DDE. DDE is used only for finding and controlling running instances.
You should always be able to start Excel manually in multiple instances.
It should always work to open sheets if done in Excel itself.

So I guess your issue is only with clicking on files in Explorer?
eemoon

ASKER
Thank you so much for your reply. My final purpose is to open multiple excel files in multiple instances. we already tried many ways to do that, such as, open anther excel instance first and then open another excel file from the new instance. and also, we can modify registry of PC to resolve the issue etc. but enable  "Ignore other application that use Dyanamic Data Exchange (DDE)" is best way. however, this way only can work for several days in my PC and then i have to disable it because i suddenly cannot open all excel files unless disable  "Ignore other application that use Dyanamic Data Exchange (DDE)"
SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
eemoon

ASKER
Your link discussed a lot on the issue. It seems changing registry is a good way. Some one changed registry for the issue successfully. but later the issue come back again. they explained the issue coming back is due to installation of new software. Do you think so? If so, how can i prevent it from happening again if another software need to install in future? In fact, my pc registry changing many times for this issue, so it caused the issue goes back again again.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
byundt

Do you think so? If so, how can i prevent it from happening again if another software need to install in future?
I cannot answer either of these questions. Instead, I suggest you conduct an experiment to see if the suggested registry tweak fixes your problem.
eemoon

ASKER
Why cannot open any excel files after enable "Ignore other application that use Dyanamic Data Exchange (DDE)"
Qlemo

Because you need to switch off the usage of DDE in the registry, too!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
eemoon

ASKER
In Excel2010, current best way is to change registry. I did it, but issue is after updating some software, the registry changed back. So I hope there is a way which can fix the changed registry and keep the registry not changed back.