Hyperlinks in Shared Workbooks

@Gary ... while I've never used this feature, I'll hazard a guess that there's a difference between storing a workbook in a shared location and telling Excel that it will be shared. In the first case, several team members might access the same copy of it, and as long as they're careful not to allow more than one person to make changes to it at once everything will be fine. But Excel allows a more sophisticated case, in which several people can have the workbook open at the same time, and changes that any of them make to it will be visible to the others "in real time". This note talks about the second case.

This (old) Microsoft article talks about this feature... https://support.microsoft.com/en-us/help/269860/how-to-use-shared-workbooks-with-different-versions-of-excel, including these steps for setting up sharing (on Excel 2007):


1. Click the Review tab.
2. Click Share Workbook in the Changes group.
3. On the Editing tab, click to select the Allow changes by more than one user at the same time. This also allows workbook merging check box, and then click OK.
4. In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.


Meanwhile, I think this qualifies as an Excel "quirk", and not a feature necessitated by how things work under the covers. Unless there's some sort of extensive validation performed on Hyperlinks when they're added to a workbook, which could not easily be done as an atomic operation and thus couldn't be done reliably in the context of a shared workbook. But that sounds unlikely. Oh well ... anything as large as Excel is bound to have its quirks, I suppose.

I have a workbook that is saved in SharePoint, and shared with our whole team. We have no problem adding hyperlinks to it, so I'm not sure I understand what is being discussed here.

Thank you!

I store the files that need to be accessible by everyone in OneDrive and copy paste the link of that file in the shared Excel workbook.

Works fine.

@Roy: You might be interested in my SuperLink function described here:
http://dailydoseofexcel.com/archives/2018/07/02/hyperlink-formula-events/#comment-1045646

To have hyperlinks that can change over time without unsharing:

BEFORE sharing, write a macro that will take a text writing of the desired hyperlink and act upon it as if it were an actual hyperlink. Macros added before sharing are always available to run. Since text can obviously be added any time, one can add new "hyperlinks" without a need to unshare and re-share.

Of course, to add it to an existing shared workbook, one would have to navigate the rocks and schoals described in Mr. Wyatt's answer.