WORD could not establish DDE connection to EXCEL to complete the t

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric_G - 02 May 2006 18:26 GMT

I am attempting a WORD merge using an EXCEL file as the data file; the data
file is quite large -- over 7500 rows / records. Each time I try to specify
the EXCEL file as the data file, I get the above-noted error message. Is
there any way to overcome this problem. I'm only assuming it has to do with
the size of the EXCEL file but am not sure.

Reply to this Message

garfield-n-odie [MVP] - 02 May 2006 19:02 GMT

See http://support.microsoft.com/kb/198299 "You receive a 'Word
could not re-establish a DDE connection to Microsoft Excel' error
message when you attach a Microsoft Excel worksheet as a
mail-merge data source in Word 2000".

> I am attempting a WORD merge using an EXCEL file as the data file; the data
> file is quite large -- over 7500 rows / records. Each time I try to specify
> the EXCEL file as the data file, I get the above-noted error message. Is
> there any way to overcome this problem. I'm only assuming it has to do with
> the size of the EXCEL file but am not sure.

Reply to this Message

Eric_G - 02 May 2006 21:10 GMT

Thanks -- tried it but to no avail. I now get the error message "Unable to
open data source" then "not enough memory to convert the data source". I
guess the file size is too big. Any suggestions?

> See http://support.microsoft.com/kb/198299 "You receive a 'Word
> could not re-establish a DDE connection to Microsoft Excel' error
[quoted text clipped - 6 lines]
> > there any way to overcome this problem. I'm only assuming it has to do with
> > the size of the EXCEL file but am not sure.

Reply to this Message

garfield-n-odie [MVP] - 02 May 2006 21:25 GMT

Every time I see someone in these newsgroups say "to no avail",
it usually means the person didn't read the instructions and/or
didn't understand the instructions and/or didn't follow the
instructions.

First, the article applies to Word 2000. Is that the version of
Word that you have? If not, then what version of Word do you have?

Second, when you say "tried it", which of the FOUR methods
suggested in the article does "it" refer to? What happens if you
try each of the other three methods?

> Thanks -- tried it but to no avail. I now get the error message "Unable to
> open data source" then "not enough memory to convert the data source". I
[quoted text clipped - 10 lines]
>>>there any way to overcome this problem. I'm only assuming it has to do with
>>>the size of the EXCEL file but am not sure.

Reply to this Message