Hi All,
Ok, here's a weird one. I got tired of hunting up master documents for all the different forms we use here. I decided to put them all in one place and create a master link Excel Sheet that would allow someone to open the form and then print it out. The forms are located on a network drive so I created a list and made hyperlinks to the document I wanted. When I initially create the link it looks like this....
*****
F:\users\COMMON\FULTON\Forms\Filling Room\Operator Run Sheets\Operator Run Sheets.XLS
*****
That would work fine and open the document. Whenever I save the document the hyperlink address changes to.....
*****
../../../../DDATA$/users/COMMON/FULTON/Forms/Filling Room/Operator Run Sheets/Operator Run Sheets.XLS
*****
This link isn't valid. Why is the address changing? How can I stop it? Is there another way to do this? Thanks
-Dan
Ok, here's a weird one. I got tired of hunting up master documents for all the different forms we use here. I decided to put them all in one place and create a master link Excel Sheet that would allow someone to open the form and then print it out. The forms are located on a network drive so I created a list and made hyperlinks to the document I wanted. When I initially create the link it looks like this....
*****
F:\users\COMMON\FULTON\Forms\Filling Room\Operator Run Sheets\Operator Run Sheets.XLS
*****
That would work fine and open the document. Whenever I save the document the hyperlink address changes to.....
*****
../../../../DDATA$/users/COMMON/FULTON/Forms/Filling Room/Operator Run Sheets/Operator Run Sheets.XLS
*****
This link isn't valid. Why is the address changing? How can I stop it? Is there another way to do this? Thanks
-Dan