I am linking files over a network. often, but not all the time, the path will
change from the named the path (i.e. s:\operations\calender\file_name.xlsx)
to the ip address of the network computer the file is on (i.e.
\\192.200.0.205\calender\file_name.xlsx)
I can't figure out why/when it happens. Is there a way to lock the path so
that it cannot be changed in the formula, but still allow the values to
update automatically.