opening source program

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ernie - 05 Dec 2005 20:26 GMT

Office XP, I have one user with a Word document that automatically loads data
from an Excel spreadsheet. In the past when she opened the Word doc the sheet
opened automatically, now it does not. How can I reset this so that opening
the Word doc also opens the Excel sheet in which she can make edits when
necessary?

Reply to this Message

Cindy M -WordMVP- - 06 Dec 2005 13:37 GMT

Hi =?Utf-8?B?RXJuaWU=?=,

> Office XP, I have one user with a Word document that automatically loads data
> from an Excel spreadsheet. In the past when she opened the Word doc the sheet
> opened automatically, now it does not. How can I reset this so that opening
> the Word doc also opens the Excel sheet in which she can make edits when
> necessary?

She needs to explicitly choose DDE as the connection method. In Word 2002 and
later the default is OLE DB.

Tools/Options/General, activate "Confirm conversions on open"
Now, when she chooses the worksheet she wants to attach, she should get a list
of connection methods and can select DDE.

Note: later versions of Office show increasing problems with DDE connections.
It's not said that this will actually work on any given installation.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message