I use excel spreadsheets (xls, DDE) as the database for my mail merge in word. After the upgrade to Word 2016, the excel open a new file (Book2) automatically when I open the word file. The main problem is that when the new excel file (Book 2) was opened, all the previous entered data was not saved and was erased. Can anyone help me to deal with this matter??
