If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2007 automatically redirects to an incorrect open source fil
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. |
#2
|
|||
|
|||
Excel 2007 automatically redirects to an incorrect open source fil
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. |
#3
|
|||
|
|||
Excel 2007 automatically redirects to an incorrect open source
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. |
#4
|
|||
|
|||
Excel 2007 automatically redirects to an incorrect open source
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 |
#5
|
|||
|
|||
Excel 2007 automatically redirects to an incorrect open source fil
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 |
#6
|
|||
|
|||
Excel 2007 automatically redirects to an incorrect open source
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 |
#7
|
|||
|
|||
Excel 2007 automatically redirects to an incorrect open source
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 |
Thread Tools | |
Display Modes | |
|
|