Links is in gray color (deactivate). How can I activate?

R

Rechie

In Edit Menu, I want to change the Links source but can do it as it is grayed.
Help please.
Thans
 
×

מיכ×ל (מיקי) ×בידן

Try, right click on cell and choose 'Edit HyperLink"
Micky
 
T

Tom Hutchins

Is the sheet protected? Or, if you have more than one sheet selected Edit >>
Links will be disabled.

Hope this helps,

Hutch
 
G

Gord Dibben

Do you know for sure you have links to External sources?


Gord Dibben MS Excel MVP
 
R

Rechie

Yes sure with link to external sources and file is not protected. I can use
right click to a cell and edit hyperlink. But I have 600 cell reference with
hyperlinks connected to single folder which contains 600 files. With this
enormous files it is better to use the "Edit" Main Menu bar so that it will
be a one time change for all my hyperlinks.

Thanks

Rechie
 
Top