Excel is auto-changing linked file name!

[SarahFWhite]

I have a .xltm document that has several cells that contain vlookups to another workbook. The formula I'm using to get the data from the other workbook is:


=IFERROR(IF(Q2="","",VLOOKUP(Q2,'V:\Store Construction\Store\[Store Construction Division Project Information.xlsm]CURRENT'!DATA,5,FALSE)),"No Data")

When I saved and closed, then reopened the file later, Excel had changed the filepath within the formula to this:

=IFERROR(IF(Q2="","",VLOOKUP(Q2,'\\Leda\Store Construction\Store\[Store Construction Division Project Information.xlsm]CURRENT'!DATA,5,FALSE)),"No Data")

I don't know how to make it stop! Now everytime the file is opened by anyone in my company they get the following error:

"This workbook contains one or more links that cannot be updated."

I've updated, edited, and refreshed the link and it's still doing it. Someone please please please help.

 

[shg]

I'm surprised it caused a problem. You used a mapped drive path, which would generally vary from machine to machine. Excel converted it to a network path, which should work for everyone that has access to the share. That seems very conscientious and thoughtful on Excel's part ...