I currently use Excel 2007 and I am working on a template with a link to an
Excel database file. For example, C:\China\Template.xlsx (File 1) has links
to a file C:\China\Data.xlsx (File 2). When I open these files together, File
1 is updated with File 2 as it should be. But if I open a different database
file C:\Brazil\Data.xlsx (File 3) first and then open C:\China\Template.xlsx
(File 2), this file automatically links to the open File 3. It automatically
links to the open database file because it has the same name? Even though the
File 1 was saved with it linked to File 2? File 2 and File 3 are not from the
same folder? I tested this on Excel 2003 (and has functioned correctly to
where the template file only links to the correct database from a specific
folder - even if other databases are named the same) and it didn't
automatically redirect the links to the open a file even if the database
files are named the same. I am not sure if there is a setting in Excel, but
fiddling around with automatic updates does not change it. A big problem is
that if the template file is saved it is saved with the redirected source
file.

Could you please help me...I don't know how to fix the settings in Excel
2007.