[Michael W]

I have multiple Named Ranges in Excel that I merge with a Word template.
After using the Step by Step Mail Merge Wizard in Word 2003 I was able to
step back to Step 3 to 'Select a different list" from the Excel file.

Now in Word 2007 when I try to open the Excel file I get the error message:
Select Data Source.
filename.xlsx
This file is in use.
Enter a new name or close the file that's open in another program."

To merge a new name range I have to close Word and start all over again.

Whats the go?