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.

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.

I don't have a solution for you but I have posted your issue on a
bug-list that is reviewed by the Excel product team and I will pass on
any feedback that they give me.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Thank you very much and please keep me posted on any fix for this.

"Bill Manville" wrote:

I don't have a solution for you but I have posted your issue on a
bug-list that is reviewed by the Excel product team and I will pass on
any feedback that they give me.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Bill:

I have another issue that we discovered and it's probably correlated with
the linking problem I presented earlier in this thread.

I get a circular error if I link a current file to another file, from a
different folder, with the same name. Example, C:\...US\Template.xlsx (File
1) has cells linking to C:\...Brazil\Template.xlsx (File 2). When
programming File 1 there are no errors, but once saved and reopened, it
removes the link and presents a circular error.

Once again, we didn't have this problem in previous versions. Please let me
know if anyone else has reported this problem and what the fix may be.

"Bill Manville" wrote:

I don't have a solution for you but I have posted your issue on a
bug-list that is reviewed by the Excel product team and I will pass on
any feedback that they give me.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Emg wrote:
Please let me
know if anyone else has reported this problem and what the fix may be.


Thanks for the additional information.
I have added it to my report to Microsoft.
I have not yet had any feedback to the earlier report but will pass it
on as soon as it comes.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup