links have the advantage that they are adaptive, meaning even if you rename or move the file around the links will still work. Numbers will honor that link, meaning you can click on the link and macOS will open the file (or reveal it in Finder, depending on your Hookmark General setting). With the Hookmark app, you can create a hyperlink to any file (protocol is hook://, they look like this: hook://file/.) (and to emails and all kinds of resources). The same text (and same limitation as to linked filed types) appears in Numbers on-line help, and in the Menu Bar at Numbers > Format > Add Link. If you don’t want Numbers to automatically detect links, you can turn off automatic link formatting.

You can edit these links or deactivate them so that they appear and behave as normal text. Numbers automatically detects valid web addresses (URLs) and email addresses and styles them (for example, with an underline or different color) to indicate that they’re active links. You can turn any text into a link that opens another sheet in the spreadsheet or opens a webpage or email message. Link to a webpage, email, or sheet in Numbers on Mac

This Apple Numbers page contains this text: Numbers cannot, however, create a link to other types of files. Numbers can create a link to a webpage, or to a sheet (in Numbers, a 'sheet' is a tab within a single spreadsheet), or to a specific email.

Out of the box, Numbers cannot link to a non-Numbers local document other than an email.

How to create hyperlink mac