Formula links in Excel

The problem is that Excel automatically converts the relative path of the linked file to an absolute path, which is specific to your computer and not accessible by others.
There are a few possible solutions to this problem:
One option is to use the HYPERLINK function in Excel, which allows you to create a clickable link to a file or website. You can use the share link feature in Dropbox to get the URL of the file you want to link to, and then use it as the first argument of the HYPERLINK function. For example, if you want to link to a file named report.xlsx stored in Dropbox, you can use this formula: =HYPERLINK("https://www.dropbox.com/s/abcd1234/report.xlsx?dl=0","Report"). This will create a link that says Report and opens the file in Dropbox when clicked.
Another option is to use the INDIRECT function in Excel, which allows you to reference a cell that contains the file path as a text string. You can store the relative path of the linked file in a cell, and then use the INDIRECT function to refer to it. For example, if you want to link to a file named report.xlsx stored in the same folder as the current file, you can enter the text =report.xlsx in cell A1, and then use this formula: =INDIRECT(A1). This will create a dynamic link that updates when the file location changes.
A third option is to use a named range in Excel, which allows you to assign a name to a cell or range of cells. You can create a named range for the linked file, and then use the name as a reference in your formula. For example, if you want to link to a file named report.xlsx stored in the same folder as the current file, you can select any cell in the file, go to the Formulas tab, click on Name Manager, and create a new name called Report with the formula =report.xlsx. Then, you can use this formula: =Report to link to the file.
I hope this helps you to create links between Excel files stored in Dropbox.