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!

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.