Discussions

Word can not re-establish a DDE connection with Excel

+
0 Votes
Locked

Word can not re-establish a DDE connection with Excel

geoff.harwood
I have had a problem merging between Word and Excel for years and could never find a solution that worked when Word states "Word could not re-establish a DDE connection". I have switched to MS Office 2007 to see if MS had resolved the problem - but no.
I am posting this because a solution I have found may help others. It appears that if an Excel spreadsheet is too large - specifically because colour has been filled infinitely across cell rows, the cell range is too large for the DDE connection. The solution is to copy the data (not the whole spreadsheet with CTRL A but just the cells containing data) into a new workbook and try the merge again. Works for me.