Create an external reference (link) to a cell range in another workbook within SHAREPOINT

Hi,   I am trying to link data from Excel 1 (source) into Excel 2. Both excels are stored within sharepoint, and are both synced so that I am opening them from my file explorer, and using the Deskt...