hyperlink navigation path path wrong in Excel 2003
 

When I create a hyperlink to a cell in Excel 2003, the link takes me to the
wrong picture in the wrong folder. No matter what picture I link to, it
always opens the same wrong picture in another folder (the first picture in
the folder one directory up). I currently have about 30 cells with
hyperlinks on them. The original 25 or so cells work just fine, but
everything new I add now just points to the same thing. Is this a bug or is
there some kind of limit to how many hyperlinks you can have in a spreadsheet?

Please help - thanks!

hyperlink navigation path path wrong in Excel 2003
 

How did you add the hyperlink?

Via Insert|Hyperlink or did you use the =hyperlink() worksheet function.

If you did Insert|Hyperlink, I'd look at that hyperlink to see if it really
points to the location that you want--just because the text displayed shows one
thing, it doesn't mean that the link is that.



CE Admin wrote:

When I create a hyperlink to a cell in Excel 2003, the link takes me to the
wrong picture in the wrong folder. No matter what picture I link to, it
always opens the same wrong picture in another folder (the first picture in
the folder one directory up). I currently have about 30 cells with
hyperlinks on them. The original 25 or so cells work just fine, but
everything new I add now just points to the same thing. Is this a bug or is
there some kind of limit to how many hyperlinks you can have in a spreadsheet?

Please help - thanks!

--

Dave Peterson

hyperlink navigation path path wrong in Excel 2003
 

I did only use the insert hyperlink method. When I hover over the link with
my mouse it shows the proper picture in the proper folder. I've never used
the =hyperlink() method. Can you provide an example of how to do this?
Thanks for your help!

"CE Admin" wrote:

When I create a hyperlink to a cell in Excel 2003, the link takes me to the
wrong picture in the wrong folder. No matter what picture I link to, it
always opens the same wrong picture in another folder (the first picture in
the folder one directory up). I currently have about 30 cells with
hyperlinks on them. The original 25 or so cells work just fine, but
everything new I add now just points to the same thing. Is this a bug or is
there some kind of limit to how many hyperlinks you can have in a spreadsheet?

Please help - thanks!

hyperlink navigation path path wrong in Excel 2003
 

and one other thing. If I save the spreadsheet as a .htm document and then
reopen it as htm, the links work just fine and point to the right picture.

"CE Admin" wrote:

I did only use the insert hyperlink method. When I hover over the link with
my mouse it shows the proper picture in the proper folder. I've never used
the =hyperlink() method. Can you provide an example of how to do this?
Thanks for your help!

"CE Admin" wrote:

When I create a hyperlink to a cell in Excel 2003, the link takes me to the
wrong picture in the wrong folder. No matter what picture I link to, it
always opens the same wrong picture in another folder (the first picture in
the folder one directory up). I currently have about 30 cells with
hyperlinks on them. The original 25 or so cells work just fine, but
everything new I add now just points to the same thing. Is this a bug or is
there some kind of limit to how many hyperlinks you can have in a spreadsheet?

Please help - thanks!

hyperlink navigation path path wrong in Excel 2003
 

I don't have a guess about the HTM saving and reopening, but you can use:

=hyperlink("File:////c:/mypicts/mypict.jpg","Click me")

Did you select the cell and Insert|hyperlink and verify the address?

CE Admin wrote:

and one other thing. If I save the spreadsheet as a .htm document and then
reopen it as htm, the links work just fine and point to the right picture.

"CE Admin" wrote:

I did only use the insert hyperlink method. When I hover over the link with
my mouse it shows the proper picture in the proper folder. I've never used
the =hyperlink() method. Can you provide an example of how to do this?
Thanks for your help!

"CE Admin" wrote:

When I create a hyperlink to a cell in Excel 2003, the link takes me to the
wrong picture in the wrong folder. No matter what picture I link to, it
always opens the same wrong picture in another folder (the first picture in
the folder one directory up). I currently have about 30 cells with
hyperlinks on them. The original 25 or so cells work just fine, but
everything new I add now just points to the same thing. Is this a bug or is
there some kind of limit to how many hyperlinks you can have in a spreadsheet?

Please help - thanks!

--

Dave Peterson

hyperlink navigation path path wrong in Excel 2003
 

Thanks Dave, that worked! I just had to turn around a few of the slashes for
it to work. Here's what I have now:

=HYPERLINK("File:////c:\CEWebx\New Pics\Debbi Graham Group/Sarah.jpg","Sarah")

Thanks again. I've been struggling with this for awhile now.

"Dave Peterson" wrote:

I don't have a guess about the HTM saving and reopening, but you can use:

=hyperlink("File:////c:/mypicts/mypict.jpg","Click me")

Did you select the cell and Insert|hyperlink and verify the address?

CE Admin wrote:

and one other thing. If I save the spreadsheet as a .htm document and then
reopen it as htm, the links work just fine and point to the right picture.

"CE Admin" wrote:

I did only use the insert hyperlink method. When I hover over the link with
my mouse it shows the proper picture in the proper folder. I've never used
the =hyperlink() method. Can you provide an example of how to do this?
Thanks for your help!

"CE Admin" wrote:

When I create a hyperlink to a cell in Excel 2003, the link takes me to the
wrong picture in the wrong folder. No matter what picture I link to, it
always opens the same wrong picture in another folder (the first picture in
the folder one directory up). I currently have about 30 cells with
hyperlinks on them. The original 25 or so cells work just fine, but
everything new I add now just points to the same thing. Is this a bug or is
there some kind of limit to how many hyperlinks you can have in a spreadsheet?

Please help - thanks!

--

Dave Peterson