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 Desktop app.
When I link them and make changes in Excel 1, the status of the updated links in Excel 2 appears as OK, although the values are not updated.
Thank you,
4 Replies
Excel Hyperlinks in Sharepoint
Hyperlinks are not working in excel sheet in sharepoint
Using hyperlinks in a workbook in the browser
Hope I was able to help you with this links
.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
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
