Networks

Problem with a mail merge document in a networked office.

At an office setup with 2 computers running Office 2007.
The files for merging into word are excel and stored on a central file server.

When opened in Word 2007 it generates the following message
<File Name> is a mail merge main document. Word cannot find it's data source, s

When you select "Find Data source" you're taken to "My data sources"

Is there any way to get these files to open?

We went through ODBC DSN for excel but we've 100's of files. Is there any way to resolve this?