[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1336
  • Last Modified:

Excel 2000: Insert Hyperlink button on toolbar remains grayed out (disabled)

Hi all,

I am using Excel 2000 on Windows XP SP2.

This is really dumb, but for the first time eveer I am trying to insert a hyperlink into a cell, and whatever i do (select text or a complete cell) the Insert Hyperlink button on the toolbar remains grayed out (disabled). Similarly does the "Insert Hyperlink" command in the Insert menu, and also the CTL-K hotkey does nothing.

A found a wierd solution: if I click Window | New Window I get a new window onto the same file, but this time Hyperlink is enabled.

What's going on? Seems like I've got a bug.

tia

- avi

0
progtw
Asked:
progtw
3 Solutions
 
zorvek (Kevin Jones)ConsultantCommented:
The Insert Hyperlink function only works on a cell selection, not when you are editing the cell. There is a difference. Try pressing the ENTER key once and see of the Insert Hyperlink command is enabled.

Kevin
0
 
BTogniettiCommented:
Also, if the workbook is shared, you cannot insert a hyperlink. If it is shared, you need to remove the share (Tools > Share Workbook > * Allow Changes...) insert the hyperlink, then share the book again.

God luck,

Bud
0
 
Rory ArchibaldCommented:
avi,
The only circumstances I can think of offhand that exactly match your description is that you have multiple sheets selected. If you were editing a cell, you shouldn't be able to use the New Window command, and if your workbook were shared, opening a new window on it would not allow you to insert a hyperlink.
Regards,
Rory
0
 
progtwAuthor Commented:
Trashed the offending file and could not reproduce the problem.

All answers sounded good so gave points to everybody.

thanks,

- avi
0
 
gswitzCommented:
In excel 2007, it is on the Review tab > Changes Group for Share Workbook.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now