Try using the =hyperlink() function instead.
--
Gary''s Student - gsnu200725


"Gruggles" wrote:

I have a spreadsheet which is a [shared] spreadsheet. Ever since it was
formatted as shared, the ability to create Hyperlinks is gone. The
spreadsheet has a lot of email addresses on it which we wish to make into
hyperlinks.

When going to the Insert menu, 'chart', 'diagram', 'object' and 'hyperlink'
are all greyed out.

Any help in this matter would be greatly appreciated.

Regards,

Greg