Shared spreadsheet and Hyperlinks

[Gosia]

How do I create Hyperlinks to files in a shared spreadsheet?
When I change preference to shared the insert Hyperlink becomes unavailbale.

 

[Gord Dibben]

That is just one of the many losses of functionality with shared workbooks.

See help on shared workbooks for more details on loss of functionality.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Use the =hyperlink() worksheet function????

How do I create Hyperlinks to files in a shared spreadsheet?
When I change preference to shared the insert Hyperlink becomes unavailbale.