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
|
|||
|
|||
Two ways into directories
Our L:drive has directories, some of which are actually a
department H:drive - so it is possible to go into the same file via the L: or H: drive - the difference being a 'department name' as the first part of the string when you go in via the L:/. This is causing problems when having links in Excel files - if you go in one way e.g. H:, if someone else goes in via the L: the links do not work / update. Is there a way for force the full 'string' of the link to remain the same and not change the h:/ to l:/'department name'/ in the link?? Hope that makes sense! |
#2
|
|||
|
|||
Two ways into directories
Sam A wrote:
Our L:drive has directories, some of which are actually a department H:drive - so it is possible to go into the same file via the L: or H: drive - the difference being a 'department name' as the first part of the string when you go in via the L:/. This is causing problems when having links in Excel files - if you go in one way e.g. H:, if someone else goes in via the L: the links do not work / update. Is there a way for force the full 'string' of the link to remain the same and not change the h:/ to l:/'department name'/ in the link?? Hope that makes sense! Hi Sam I think is almost the same area as I have just been asking about, see the news group below this post called "Filenames in links". Your problem is with the PATH mine was the filename. I think if you make your link with a relative path and use INDIRECT or INDIRECT.EXT you will have success. I have a cell Named PATH the formula in the cell uses =LEFT(CEll("Filename";SEARCH("[";Cell("Filename"))-1) This gives me the complete path that I am using at this point in time. Add this to INDIRECT. =INDIRECT("'" & PATH & "[workbook-name]Sheet1'!A1") where A1 is the link address or Cell name. INDIRECT.EXT works with closed workbooks. Hope that made sense. |
Thread Tools | |
Display Modes | |
|
|