ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   saved hyperlinks do not keep the file association, all revert to . (https://www.excelbanter.com/excel-discussion-misc-queries/10804-saved-hyperlinks-do-not-keep-file-association-all-revert.html)

rjdrw

saved hyperlinks do not keep the file association, all revert to .
 
I set the path of the hyperlink to the following location on my server:
Z:\Dwg_Data\Manorwood\Roof\Trusses_2004\Truss_05A. dwg

Once I save the document, close it, and reopen it the hyperlinks revert to
My Network Places in the following location:
Eng_Logs on 'Snap! Server 192.1.7.189 (Snap134170)'

is there a setting that I am missing?

Please help, I have hundreds of hyperlinks to change and use them every day.

Thanks.


Dave Peterson

I'd try using the UNC name instead of the mapped drive.

="\\server\share\Dwg_Data\Manorwood\Roof\Trusses_2 004\....
instead of
="Z:\Dwg_Data\Manorwood\Roof\Trusses_2004\....

rjdrw wrote:

I set the path of the hyperlink to the following location on my server:
Z:\Dwg_Data\Manorwood\Roof\Trusses_2004\Truss_05A. dwg

Once I save the document, close it, and reopen it the hyperlinks revert to
My Network Places in the following location:
Eng_Logs on 'Snap! Server 192.1.7.189 (Snap134170)'

is there a setting that I am missing?

Please help, I have hundreds of hyperlinks to change and use them every day.

Thanks.


--

Dave Peterson

Dave Peterson

I also like to use the worksheet function:
=hyperlink()

I've never seen it "fix" the links.

rjdrw wrote:

I set the path of the hyperlink to the following location on my server:
Z:\Dwg_Data\Manorwood\Roof\Trusses_2004\Truss_05A. dwg

Once I save the document, close it, and reopen it the hyperlinks revert to
My Network Places in the following location:
Eng_Logs on 'Snap! Server 192.1.7.189 (Snap134170)'

is there a setting that I am missing?

Please help, I have hundreds of hyperlinks to change and use them every day.

Thanks.


--

Dave Peterson


All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com