External Data Network Path Keeps Changing

[David20]

I have a workbook, stored as Read-Only on a network, that has external data links (for vlookup functions) to files on the same network but different folders.

My problem is that the network path in the formulas seem to randomly change. I started with a full path, \\server\folder\folder\file. Occasionally the path will change to match my mapped drive, Z:\folder\file, but the data links usually still work.

Today it change to C:\folder\file, which is, of course, completely wrong and the data links won't work at all.

It's a large file with 100+ links. When this happens it costs me a lot of time to fix. Anybody out there know how I can prevent this? I'm using 2007, as are the other people in the office who use the workbook.

Thanks.

 

[SamTYler]

idunnonutink, but UDFs might work.

Public Function EastDivision3rdQtrSalesPath () As String
OnError Goto Oops
EastDivision3rdQtrSalesPath = "'\\server\EastDivision\3rd Qtr\Sales'"
Exit Function
Oops:
EastDivision3rdQtrSalesPath = "error"
End Function

of course that means you get to rewrite all 100 formulas one more time

=If(EastDivision3rdQtrSalesPath="error","",VlookUp((EastDivision3rdQtrSalesPath+totals) etc)

 

[David20]

No luck. Thanks for the input, though.