Solved

DDE waiting for Excel command in Word merge

Posted on 2008-10-14
3
1,324 Views
Last Modified: 2012-08-13
The PC owner regularly opens up a MS Word document that has a Excel spreadsheet merged to it.  All of a sudden it now gets an error message "Waiting for Microsoft Excel to accept DDE Commands".

We renamed the xls file xxxxOLD and pasted a backup of the file to the directory but got the same error message.

By the way, the backup file had not been updated for several months.  The DDE error message originates from a Word file just a few days old.

Any ideas?
0
Comment
Question by:michealbeethoven
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
pkhari earned 500 total points
ID: 22717620
Try this:

If in Office 2007: Go to->File (Office button)->Excel Options->Advanced->General section, and check the box on "Ignore other applications that use Dynamic Data Exchange (DDE)".

If in 2003, this option comes under Tools->Options->General->Settings section->Ignore other applications

Hope this helps.

Cheers
P.K.
0
 
LVL 10

Assisted Solution

by:pkhari
pkhari earned 500 total points
ID: 22717681
Ok, I should have told you this - just do the reverse if your box is already ticked - meaning clear the check box.

Second option is to activate the conversion option in Word file. Under Tools->Options in 2003. (In 2007, it is under Office button->Word Options->Advanced->General section->Confirm file format conversion on open). Once you do this and save and reopen the file, you should be able to try various opions like using either DDE or ODBC. Try either one and see which one works for your situaion.

The last one I can think of is to relink the source data - achieved by renaming the current excel data source and when reopening Word, you will get an error saying data source not found. You can now select the new file and try moving ahead.

Hope this helps.

Cheers
P.K.

Some links for you:
http://www.wincert.net/forum/index.php?showtopic=2322
http://groups-beta.google.com/group/microsoft.public.word.mailmerge.fields/browse_frm/thread/f1578328b1e5bf9d/d6437ab462b6914e?lnk=st&q=Waiting+for+microsoft+excel+to+accept+dde+command&rnum=6&hl=en#d6437ab462b6914e
0
 

Author Closing Comment

by:michealbeethoven
ID: 31506165
Hello pkhari:

Thanks for the help, but, ultimately, the only solution was to uninstall/install MS Office.  I awarded you points for participation.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question