Solved

DDE waiting for Excel command in Word merge

Posted on 2008-10-14
3
1,314 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now