Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Link Properties Dialog Box
This dialog box displays every time the name of the Source Document changes.
However, when the new Source Document is selected and the "OK" button is click and the Word file is saved, the new Source Document is not retained. We have to cancel the Data Link Properties box to get the next prompt box which allows us to "Find the Source Document". When we use this process the new Source Document is retained. What are we doing wrong? One would think that the Data Link Properties box would retain that information. We are having to make many more clicks than is necessary. Is there a setting we need to change? Thanks in advance. |
#2
|
|||
|
|||
Which version of Word (and service pack) and what type of data source are
you trying to connect to? Peter Jamieson "Steven" wrote in message ... This dialog box displays every time the name of the Source Document changes. However, when the new Source Document is selected and the "OK" button is click and the Word file is saved, the new Source Document is not retained. We have to cancel the Data Link Properties box to get the next prompt box which allows us to "Find the Source Document". When we use this process the new Source Document is retained. What are we doing wrong? One would think that the Data Link Properties box would retain that information. We are having to make many more clicks than is necessary. Is there a setting we need to change? Thanks in advance. |
#3
|
|||
|
|||
Word 2003 SP1 and Excel spreadsheet (I believe created in Excel 2002 [XP]) as
the data source. Thanks in advance "Peter Jamieson" wrote: Which version of Word (and service pack) and what type of data source are you trying to connect to? Peter Jamieson "Steven" wrote in message ... This dialog box displays every time the name of the Source Document changes. However, when the new Source Document is selected and the "OK" button is click and the Word file is saved, the new Source Document is not retained. We have to cancel the Data Link Properties box to get the next prompt box which allows us to "Find the Source Document". When we use this process the new Source Document is retained. What are we doing wrong? One would think that the Data Link Properties box would retain that information. We are having to make many more clicks than is necessary. Is there a setting we need to change? Thanks in advance. |
#4
|
|||
|
|||
Just checking: is your Word document's data source set up using code, e.g.
is it being opened from another program, or is there an "Auto macro" that runs when the document opens. If so, you need to look at http://support.microsoft.com?kbid=825765 However, I doubt if it is that. Your simplest approach may be to try to connect to the Excel file using the old method - try checking Word Tools|Options|General|Confirm conversions at open, then re-making the connection to the data source. Excel will need to be installed for that to work. Other things to try include: 1. recreate a couple of your spreadsheets from scratch (certain types of corruption may now cause problems) 2. move your spreadsheets to a different location, preferably on a local machine with a short pathname 3. If you want to investigate the existing approach a little bit further (and I do not hold out much hope of success), try the following... Once you have successfully supplied a new data source, can you a. leave it open b. open up the VBA Editor (Word Tools|Macro|Visual Basic Editor), open the Immediate Window (see the View menu), type (or copy from this message) Print ActiveDocument.MailMerge.DataSource.Name then enter return, and note the value "printed" then do the same for Print ActiveDocument.MailMerge.DataSource.ConnectString Print ActiveDocument.MailMerge.DataSource.QueryString c. tell us what the results were. Peter Jamieson "Steven" wrote in message ... Word 2003 SP1 and Excel spreadsheet (I believe created in Excel 2002 [XP]) as the data source. Thanks in advance "Peter Jamieson" wrote: Which version of Word (and service pack) and what type of data source are you trying to connect to? Peter Jamieson "Steven" wrote in message ... This dialog box displays every time the name of the Source Document changes. However, when the new Source Document is selected and the "OK" button is click and the Word file is saved, the new Source Document is not retained. We have to cancel the Data Link Properties box to get the next prompt box which allows us to "Find the Source Document". When we use this process the new Source Document is retained. What are we doing wrong? One would think that the Data Link Properties box would retain that information. We are having to make many more clicks than is necessary. Is there a setting we need to change? Thanks in advance. |
#5
|
|||
|
|||
Thanks for all the help Peter. However, after applying updates KB885828 and
KB887979, and adding the registry key mentioned in article 885832 the Data Link Properties dialog box no longer appears. The process goes straight to the prompt box that allows us to "Find the Data Source" and the change is retained. Thanks again for all the help. "Peter Jamieson" wrote: Just checking: is your Word document's data source set up using code, e.g. is it being opened from another program, or is there an "Auto macro" that runs when the document opens. If so, you need to look at http://support.microsoft.com?kbid=825765 However, I doubt if it is that. Your simplest approach may be to try to connect to the Excel file using the old method - try checking Word Tools|Options|General|Confirm conversions at open, then re-making the connection to the data source. Excel will need to be installed for that to work. Other things to try include: 1. recreate a couple of your spreadsheets from scratch (certain types of corruption may now cause problems) 2. move your spreadsheets to a different location, preferably on a local machine with a short pathname 3. If you want to investigate the existing approach a little bit further (and I do not hold out much hope of success), try the following... Once you have successfully supplied a new data source, can you a. leave it open b. open up the VBA Editor (Word Tools|Macro|Visual Basic Editor), open the Immediate Window (see the View menu), type (or copy from this message) Print ActiveDocument.MailMerge.DataSource.Name then enter return, and note the value "printed" then do the same for Print ActiveDocument.MailMerge.DataSource.ConnectString Print ActiveDocument.MailMerge.DataSource.QueryString c. tell us what the results were. Peter Jamieson "Steven" wrote in message ... Word 2003 SP1 and Excel spreadsheet (I believe created in Excel 2002 [XP]) as the data source. Thanks in advance "Peter Jamieson" wrote: Which version of Word (and service pack) and what type of data source are you trying to connect to? Peter Jamieson "Steven" wrote in message ... This dialog box displays every time the name of the Source Document changes. However, when the new Source Document is selected and the "OK" button is click and the Word file is saved, the new Source Document is not retained. We have to cancel the Data Link Properties box to get the next prompt box which allows us to "Find the Source Document". When we use this process the new Source Document is retained. What are we doing wrong? One would think that the Data Link Properties box would retain that information. We are having to make many more clicks than is necessary. Is there a setting we need to change? Thanks in advance. |
#6
|
|||
|
|||
Good, thanks for the useful feedback.
Peter Jamieson "Steven" wrote in message ... Thanks for all the help Peter. However, after applying updates KB885828 and KB887979, and adding the registry key mentioned in article 885832 the Data Link Properties dialog box no longer appears. The process goes straight to the prompt box that allows us to "Find the Data Source" and the change is retained. Thanks again for all the help. "Peter Jamieson" wrote: Just checking: is your Word document's data source set up using code, e.g. is it being opened from another program, or is there an "Auto macro" that runs when the document opens. If so, you need to look at http://support.microsoft.com?kbid=825765 However, I doubt if it is that. Your simplest approach may be to try to connect to the Excel file using the old method - try checking Word Tools|Options|General|Confirm conversions at open, then re-making the connection to the data source. Excel will need to be installed for that to work. Other things to try include: 1. recreate a couple of your spreadsheets from scratch (certain types of corruption may now cause problems) 2. move your spreadsheets to a different location, preferably on a local machine with a short pathname 3. If you want to investigate the existing approach a little bit further (and I do not hold out much hope of success), try the following... Once you have successfully supplied a new data source, can you a. leave it open b. open up the VBA Editor (Word Tools|Macro|Visual Basic Editor), open the Immediate Window (see the View menu), type (or copy from this message) Print ActiveDocument.MailMerge.DataSource.Name then enter return, and note the value "printed" then do the same for Print ActiveDocument.MailMerge.DataSource.ConnectString Print ActiveDocument.MailMerge.DataSource.QueryString c. tell us what the results were. Peter Jamieson "Steven" wrote in message ... Word 2003 SP1 and Excel spreadsheet (I believe created in Excel 2002 [XP]) as the data source. Thanks in advance "Peter Jamieson" wrote: Which version of Word (and service pack) and what type of data source are you trying to connect to? Peter Jamieson "Steven" wrote in message ... This dialog box displays every time the name of the Source Document changes. However, when the new Source Document is selected and the "OK" button is click and the Word file is saved, the new Source Document is not retained. We have to cancel the Data Link Properties box to get the next prompt box which allows us to "Find the Source Document". When we use this process the new Source Document is retained. What are we doing wrong? One would think that the Data Link Properties box would retain that information. We are having to make many more clicks than is necessary. Is there a setting we need to change? Thanks in advance. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data link properties pop up when i select choose contacts folder | New Users | |||
"Data Link properties" | New Users | |||
Select Table dialog box after choosing data source | Mailmerge | |||
Select Table dialog box after choosing data source | Mailmerge | |||
Data Link Properties Window shouldn't come up. | Mailmerge |