How to set up links in Excel so they don't break between Mac and Windows?

Question

macOS

There are two computers: with MacOS and Windows. Both are configured to connect to the server.
Through a computer on Windows, a table is created on the server, into which data is inserted from a dozen other tables on the same server. The paths in the table cells look something like this: K/Folder/Table.xlxs, that is, they access the server as a disk.
When a user on a Mac opens this table, then all links fly off, because on a Mac, the path to the server is not a disk, but an IP address. If you remake links from a Mac, they will no longer open on Windows.
I looked in the Excel documentation for some other approach to inserting links to other tables, but only the one we use is described there. Is there a way to make table links work on both systems?

Answer 1

VBA + system identifier,
but the launch of VBA itself can also be prohibited, but you can configure it to save in two versions