how do i lock the external file (link) path so that it does not ch
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. |
All times are GMT +1. The time now is 06:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com