workbook links to .xla file on the network
 

Great day!
I have few custom functions in the C:/my.xla file. If I add my.xla to
the workbook on my local drive and use functions from it everything is
fine but the minute I copy workbook to the network (lets say drive F)
and try to open it then link to the C:/my.xls automatically changes to
F:/my.xla and formulas do not work anymore.
Is there a way to permanently specified the path to my.xla?
Thank you!


--
compound
------------------------------------------------------------------------
compound's Profile: http://www.excelforum.com/member.php...o&userid=11556
View this thread: http://www.excelforum.com/showthread...hreadid=384997