Forum Discussion
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...
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.
My knowledge of sharepoint is very limited, the only thing I can offer you is this link.
Add a link in a document library
thx