ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hyperlink problem (https://www.excelbanter.com/excel-worksheet-functions/226239-hyperlink-problem.html)

Petervan

Hyperlink problem
 
In Excel 2003, I am having trouble with hyperlinks made to files on the
company server. Everything works fine until I save the file. At this point
the address for the hyperlink is modified from the specific one I chose
originally to one that starts with ../../../ which doesn't work. Hyperlinks
made in other cells to web sites, in the same file, are not affected this
way. Any ideas?
--
Thanks for your help

Héctor Miguel

Hyperlink problem
 
hi, Petervan !

In Excel 2003, I am having trouble with hyperlinks made to files on the company server.
Everything works fine until I save the file. At this point the address for the hyperlink is modified
from the specific one I chose originally to one that starts with ../../../ which doesn't work.
Hyperlinks made in other cells to web sites, in the same file, are not affected this way. Any ideas?


try the worksheet-function: =hyperlink("UNC to your server path","text in cell")

hth,
hector.




All times are GMT +1. The time now is 07:39 PM.

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