hard to open excel while debugging

R

Rudy Ray Moore

Anybody notice that while debugging, excel (and some other apps) have a
"hard time" opening? Anybody know why this is?

"hard time" - takes 20 seconds to open, low CPU usage.

I'm using VC++ .net/2003/7.1, native code.

Rudy
 
J

Julie

Rudy said:
Anybody notice that while debugging, excel (and some other apps) have a
"hard time" opening? Anybody know why this is?

"hard time" - takes 20 seconds to open, low CPU usage.

I'm using VC++ .net/2003/7.1, native code.

Rudy

It has to do w/ the DDE server getting blocked (DDE makes extensive use of
window messaging, and if the application you are debugging is at a breakpoint
(essentially blocked), then the DDE server will hang around waiting for that
app to respond before timing out and moving to the next app -- it is quite a
bit more involved, you can search old DevNet library articles on DDE, etc. for
further details).

To 'fix' the problem, you need to edit the file types that you want to have
more responsive so they don't use DDE during file open.

In your Excel example, you need to do the following:

Control Panel/Folder Options/File Types

Scroll down to XLS (or type in XLS and it will scroll down for you), click on
Advanced, Click on open action, edit, and then clear the Use DDE checkbox.

This should solve your 'problem', however you need to be aware that it may
cause some unintended side-effects (i.e. multiple instances of Excel running
instead of multiple worksheets opening in a single instance of Excel). Make a
note of the DDE settings if you want to restore to the previous configuration.

If it works for you, you will have to make the above change to all of the file
types that you want affected.
 
R

Rudy Ray Moore

Thanks so much Julie!

Julie said:
It has to do w/ the DDE server getting blocked (DDE makes extensive use of
window messaging, and if the application you are debugging is at a breakpoint
(essentially blocked), then the DDE server will hang around waiting for that
app to respond before timing out and moving to the next app -- it is quite a
bit more involved, you can search old DevNet library articles on DDE, etc. for
further details).

To 'fix' the problem, you need to edit the file types that you want to have
more responsive so they don't use DDE during file open.

In your Excel example, you need to do the following:

Control Panel/Folder Options/File Types

Scroll down to XLS (or type in XLS and it will scroll down for you), click on
Advanced, Click on open action, edit, and then clear the Use DDE checkbox.

This should solve your 'problem', however you need to be aware that it may
cause some unintended side-effects (i.e. multiple instances of Excel running
instead of multiple worksheets opening in a single instance of Excel). Make a
note of the DDE settings if you want to restore to the previous configuration.

If it works for you, you will have to make the above change to all of the file
types that you want affected.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top