I have a word mail merge for letters using an excel file as the data source. My problem is that I am not able to have both files open at the same time for editing (i.e. the excel source data and the word mail merge file)
When I open excel first, then try to open word, i get an error message that the file is already open in another application and word can't use it! When I open word first and then try to open it in excel, excel opens it in read-only mode
I would think this is normal, but I've seen many video tutorials on mail merge and it shows both apps
Does anyone know why this is and how to fix it?
EDIT:
I am running Office 2016 on Windows 10 Pro