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!

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

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!

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!

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

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
>