Absolute Path change ...

[Sige]

Hi There,

In my workbook I have some absolute links like:
='S:\finplan\2005\BR9 2005\snackfood\[account profitability
..xls]BR9'!B$100
This link work perfect!

I noticed though that sometimes, for some mystic reason, the link
changes into:
='E:\finplan\2005\BR9 2005\snackfood\[account profitability
..xls]BR9'!B$100
(Without "updata links", nothing happens of course ... but updating the
links causes: # REFs) all over ...

I cannot simulate this bizar change now; but I am just sure it has
happened, as this change has happened to plenty of my files...
Any reason why Excel changes this drive mapping...?

I hope excel.misc is the right place to ask,

Best Regards Sige

 

[Dave Peterson]

I've always found it better to use the UNC path when pointing to a shared
network drive.

I'm gonna guess (and it's just a guess) that someone else maps to that same
location as E and that changed the mapped letter.

I'd try to use:

="'\\servername\sharename\finplan\.....

Hi There,

In my workbook I have some absolute links like:
='S:\finplan\2005\BR9 2005\snackfood\[account profitability
.xls]BR9'!B$100
This link work perfect!

I noticed though that sometimes, for some mystic reason, the link
changes into:
='E:\finplan\2005\BR9 2005\snackfood\[account profitability
.xls]BR9'!B$100
(Without "updata links", nothing happens of course ... but updating the
links causes: # REFs) all over ...

I cannot simulate this bizar change now; but I am just sure it has
happened, as this change has happened to plenty of my files...
Any reason why Excel changes this drive mapping...?

I hope excel.misc is the right place to ask,

Best Regards Sige

 

[David McRitchie]

possibly a backup file, a restored file or a device was
involved when Excel was up. If you restore a file you want
to restore it to the same place with Excel down. Excel keeps track of
pathname for macros. Excel can have only one filename.ext
open at a time. Tell us what you found out or if Dave Peterson's
suggestion works -- if you would know over a short period of time.

 

[Sige]

Hi David, Dave,

As Dave guessed:

I'm gonna guess (and it's just a guess) that someone else maps to that same
location as E and that changed the mapped letter.

It is exactly what happens (-ed).

\\MFBNW1\DATA\SHARED\....
does the trick...
Thanks a lot!!!
Sige

I know this is a network issue, but how does it come actually that
someone else accesses the same location via a "different" drive..

 

[Dave Peterson]

There's nothing sacred about what letters you can map network drives to (well,
any letter eaten by the local pc would be already taken (A: and C: (and cd/dvd
drives).

But you could make it a training issue (never works 100%) to always use a
certain letter to get to a certain share name--but there's always an exception.

And another thing that makes the UNC path a little nicer is that there can be
way more than 26 drives that people need to access.

But it's not always good. Someday, your IT department will retire \\mfbnw1 and
when they get a replacement server, they might not use the same name (or they
might??). That should keep you busy for a couple of days updating your
workbooks with the links <vbg>.

 

[Sige]

Thank you Dave,

Someday, your IT department will retire \\mfbnw1 and
when they get a replacement server, they might not use the same name (or they
might??). That should keep you busy for a couple of days updating your
workbooks with the links <vbg>.

When that day comes ... I go on holidays for a couple of weeks!

Thanks again, Sige