EMG -
I have encountered the same problem. The rep at Microsoft was able to
recreate the error and has basically admitted that it's a bug in the program.
Unfortunately, I don't think it will get fixed until the next service pack.

I have not found any other ways around it other than giving the files
different names.

It's a scary problem.

"EMG" wrote:

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.

Thanks CPA Dan. I hope Microsoft will have a fix for this soon.

"CPA Dan" wrote:

EMG -
I have encountered the same problem. The rep at Microsoft was able to
recreate the error and has basically admitted that it's a bug in the program.
Unfortunately, I don't think it will get fixed until the next service pack.

I have not found any other ways around it other than giving the files
different names.

It's a scary problem.

"EMG" wrote:

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.