We are having a nightmare with one Excel file that has been used for several
years as a data source into a report created in Word.
Since converting to Office XP, we have always had Word set to "Confirm
Conversion at Open" and advotcated DDE as the appropriate choice, when asked.
This was the default before Microsoft made the change to OLEDB (why they
fixed something that wasnt broken will forever remain a mystery to me).
In any event, this one Excel file refuses to make the DDE connection.
I found an article at http://support.microsoft.com/kb/198299 and we tried
each of the suggested fixes, to no avail. I specify WE because when I
failed, I asked several other computer literate individuals to give it a try,
as well.
I have done the Open and Repair on the file from the Open button, scanned
for virus, etc.
There are currently 7246 records, out to column Y. Rekeying the file is out
of the question.
Any additional suggestions will be greatly appreciated.
Paul