Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shifting Hyperlink
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shifting Hyperlink
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") Blake wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) |