Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
CE Admin
 
Posts: n/a
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
CE Admin
 
Posts: n/a
Default 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!

  #4   Report Post  
Posted to microsoft.public.excel.misc
CE Admin
 
Posts: n/a
Default 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!

  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.misc
CE Admin
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I open a Quattro Pro 7.0 file in Excel 2003 cpatrick83 Excel Discussion (Misc queries) 0 August 22nd 05 09:41 PM
LINEST bug in Excel 2003 mathman Excel Worksheet Functions 11 June 21st 05 02:05 PM
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
quattro pro converter Excel 2003 dr88363 New Users to Excel 0 February 27th 05 06:00 PM


All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"