General discussion


Word can not re-establish a DDE connection with Excel

By 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.

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums