I have a mail merge setup with my main document in Word 2000 and the data in an Excel 2000 spreadsheet. I've had the same document merge setup on many computers for the past several years. Suddenly, on one computer, when opening the main Word document, it hangs with "Waiting for Microsoft Excel to accept DDE commands". I can open the Excel document by itself but not the Word document. The only way I've able to fix this in the past by completely uninstalling and reinstalling Office. No changes are made to the main document or the Excel data file.
Why does it suddenly stop working? There must be an easier way to fix this than uninstalling and reinstalling Office, especially because all of the installations are are remote offices.
Any ideas on how to fix this?