Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve
 
Posts: n/a
Default hyperlinks work for some but not others

Some people cannot access hyperlinks in another building. The links are all
excel files and are all in an excel file. Some people can access all links,
some can only access 2, some can access all but the 2 others can access and
some can't access any at all. When i change the way i set the hyperlinks up
it seems to have an impact on who can access the links....help!!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default hyperlinks work for some but not others

Lots of people write about hyperlinks (inserted via the insert|hyperlink menu)
get changed when opened on another pc.

I'm guessing that the links point to a network drive.

I always had better luck using the UNC path (\\server\sharename\folder\file.xls)
rather than the mapped drive (M:\folder\file.xls).

And you may want to try to change the hyperlink base:
File|Properties|summary tab
hyperlink base box:
Change it to C:\
(as long as the links to point to the c: drive)

======
But what's worked best for me is to use the =hyperlink() worksheet function.
You may want to try that.

Steve wrote:

Some people cannot access hyperlinks in another building. The links are all
excel files and are all in an excel file. Some people can access all links,
some can only access 2, some can access all but the 2 others can access and
some can't access any at all. When i change the way i set the hyperlinks up
it seems to have an impact on who can access the links....help!!!


--

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
Losing hyperlinks RedChip Excel Discussion (Misc queries) 0 November 30th 05 10:56 AM
Work book shared kiran Excel Discussion (Misc queries) 8 June 22nd 05 05:47 AM
Work book formulas Jessica Excel Discussion (Misc queries) 1 June 9th 05 10:51 AM
Hyperlinks and sorting data Rena Excel Discussion (Misc queries) 0 June 3rd 05 07:50 PM
Hyperlinks in PowerPoint gbrais New Users to Excel 0 November 28th 04 06:49 PM


All times are GMT +1. The time now is 07:20 PM.

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

About Us

"It's about Microsoft Excel"