Add/edit Hyperlink in shared excel workbook

[Sana]

I have a shared Excel work book containing many
hyperlinks. The users add or edit the hyperlinks every
time during the day. The problem is that in order to add
or edit a hyperlink one has to take off the shared
workbook.
Can any one help me out here I want to share the file and
add and edit the hyperlinks without kining out other users.



Thanks
sana

 

[Dave Peterson]

This is from xl2002's help:

Features that are unavailable in shared workbooks
You can access the following features only if you stop sharing the workbook.
......
Insert or change hyperlinks Existing hyperlinks continue to work.

 

[sana]

Is there any alternate you can suggest....

-----Original Message-----
This is from xl2002's help:

Features that are unavailable in shared workbooks
You can access the following features only if you stop sharing the workbook.
......
Insert or change hyperlinks Existing hyperlinks continue to work.



--

Dave Peterson
(e-mail address removed)
.

 

[Dave Peterson]

Maybe you could use a worksheet formula:

=hyperlink("http://www.microsoft.com","friendly name here")

xl2002 allowed this type of hyperlink with a shared workbook.