Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
dde Word with Excel
I have a Word doc (as a mail merge) connected to an Excel database. On the machines that work correctly, when I open the file I get the message "opening this document will run the following SQL command CONNECT*FROM {doc name and path}. When I answer yes to continue, the doc opens as does Excel, and the database is attached.
On the machines not working, after I answer yes, it says "Word cannot fine data source", and I need to manually re-connect through dde. If I save, close, and re-open, I still need to reconnect. Sometimes I must remove the headers before it will allow me to reconnect. This happens on all of my mail merge docs (which ran fine before I updated Windows and Office)
Am I missing a switch/setting on the 2 machines?
Any help is greatly appreciated. The problem has brought my office to a standstill!