Forum Discussion

inesgg's avatar
inesgg
Copper Contributor
Jan 21, 2022

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...
excel
  • inesgg's avatar
    inesgg
    Copper Contributor
    Jan 23, 2022

    NikolinoDE Thank you for your answer but no, none of these work because I am trying to reference a file that is stored within sharepoint, not in my local drive.

     

    It's not really hyperlinks that I need as I don't need the other document to open when clicking on it, it's just a file that collects the data from another file.

     

    Additionally, when updating the links the status displayed is OK, but the numbers are not updated.

     

    Thanks for other suggestions.

Resources