Shifting Hyperlink

B

Blake

I have noticed when swapping excel files from one laptop to another that
hyperlinks tend to shift up one row. For example if i click the link in row
15 the web page assosicated with row 14 will apear in the web browser. I
have had to fix this problem manualy twice now and would rather not do it
again. I am running Office 2003 on all machines, any advice as to why this
happens or how to prevent it would be great
 
D

Dave Peterson

If you're using Insert|hyperlink, try changing the base address:

File|Properties|summary tab (near the bottom of the dialog)

(Point at the C:\ folder--it should be available for all users????)

But I've never had any trouble using the =hyperlink() worksheet formula.

=hyperlink("file:////c:\my documents\word\doc1.doc","Click Me")
 
Top