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 LINKS
I have inherited some spreadsheets and there are links in -
no problem with that in itself. However, as a general principle, what happens when you create further versions of the file? It gets updated from time to time, and previous users have apparently created the "next" version by File Save as. It looks to me as though the links in the *related* files change to point to the newly-saved file, and although I can understand the logic it seems to me that you should really be offered the option of making the change. As far as I can tell, making a copy in any other way such as via Explorer leaves the links pointing to the original file. I know I can change the links by Edit Links, but can anyone confirm that what I have outlined is correct, and if they know of any way of preventing it happening in the first place? A number of users have access to these files, from different locations, and not all of them will realise what is happening behind the scenes, so there is a danger they will blithely go on assuming a link is doing one thing when in reality it is doing something completely different! Thanks for any thoughts/comments etc |
#2
|
|||
|
|||
EXCEL LINKS
If workbook B links data in workbook A, and the name of A is renamed
using Windows Explorer, then the links in B will no longer work. If a new copy of A is created and named C by SaveAs, then - if B is not open, then B will continue to link to A - if B is open, then the open version of B will now point to C. However, the permanent (disk) version of B continues to point to A, unless B is saved. Jerry Mike B wrote: I have inherited some spreadsheets and there are links in - no problem with that in itself. However, as a general principle, what happens when you create further versions of the file? It gets updated from time to time, and previous users have apparently created the "next" version by File Save as. It looks to me as though the links in the *related* files change to point to the newly-saved file, and although I can understand the logic it seems to me that you should really be offered the option of making the change. As far as I can tell, making a copy in any other way such as via Explorer leaves the links pointing to the original file. I know I can change the links by Edit Links, but can anyone confirm that what I have outlined is correct, and if they know of any way of preventing it happening in the first place? A number of users have access to these files, from different locations, and not all of them will realise what is happening behind the scenes, so there is a danger they will blithely go on assuming a link is doing one thing when in reality it is doing something completely different! Thanks for any thoughts/comments etc |
#3
|
|||
|
|||
EXCEL LINKS
Jerry
Thanks for that - I think I follow! Mike B -----Original Message----- If workbook B links data in workbook A, and the name of A is renamed using Windows Explorer, then the links in B will no longer work. If a new copy of A is created and named C by SaveAs, then - if B is not open, then B will continue to link to A - if B is open, then the open version of B will now point to C. However, the permanent (disk) version of B continues to point to A, unless B is saved. Jerry Mike B wrote: I have inherited some spreadsheets and there are links in - no problem with that in itself. However, as a general principle, what happens when you create further versions of the file? It gets updated from time to time, and previous users have apparently created the "next" version by File Save as. It looks to me as though the links in the *related* files change to point to the newly-saved file, and although I can understand the logic it seems to me that you should really be offered the option of making the change. As far as I can tell, making a copy in any other way such as via Explorer leaves the links pointing to the original file. I know I can change the links by Edit Links, but can anyone confirm that what I have outlined is correct, and if they know of any way of preventing it happening in the first place? A number of users have access to these files, from different locations, and not all of them will realise what is happening behind the scenes, so there is a danger they will blithely go on assuming a link is doing one thing when in reality it is doing something completely different! Thanks for any thoughts/comments etc . |
Thread Tools | |
Display Modes | |
|
|