Microsoft KB Archive/121699

= WD: Excel Worksheet Data Source Saves as MacWord Document =

Article ID: 121699

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Word 6.0 for Macintosh
 * Microsoft Word 98 for Macintosh

-



This article was previously published under Q121699



SYMPTOMS
If you use a Microsoft Excel worksheet as a mail merge data source, Microsoft Word saves the worksheet in Word document format if you click Yes when prompted to save the data source. In other words, Word overwrites the Microsoft Excel worksheet with a Word document if you click Yes in response to the following message:

 is a mail merge main document that is attached to a data source  that has not been saved. Do you want to save ?

Word does not warn you that the Microsoft Excel worksheet will be overwritten with a Word document.

This does not happen with Word for Windows.



WORKAROUND
If your mail merge data source is a Microsoft Excel worksheet, do not modify it by clicking the Edit Data Source button on the Mail Merge toolbar in Word. Instead, open the worksheet in Microsoft Excel, modify it, and then save it in Microsoft Excel.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

