Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
opening source program
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
opening source program
Hi ?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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening multiple documents in the same program window | Microsoft Word Help | |||
Word 2003 program is slow when opening or starting up | Microsoft Word Help | |||
Opening a word document with another program | Microsoft Word Help | |||
How do I get all my Word documents within one Word window | Microsoft Word Help | |||
Mail merge source document hangs on opening | Mailmerge |