Forum Discussion
Help on making reference to multiple excel sheets saved on Microsoftteams
As soon as you sync the file on SharePoint to local drive it is updated automatically in both ways, changed you it on cloud or locally. Didn't catch why you have to repeat that each time.
If you use Excel for web (same as for Teams) it supports now links to external files, it's not necessary to land the file into local drive.
If Consolidated is used locally, another alternative could be Power Query.
If you'd like the files work the same way on web and locally more, that will be more complex scenario.
Just to clarify what you meant by "If you use Excel for web (same as for Teams) it supports now links to external files, it's not necessary to land the file into local drive.", you mean if I used "=" to reference between the two sheets whether on Teams or excel for web, it will work? I had always thought it couldn't based on what I saw on the forums.
Yes, in Excel for web it works. It looks like
First time the link is added you need to click Trust workbook links, but that's only first time.
Initiating the link is the same way as in desktop - open both workbooks in browser, in cell start with =, click on the cell in another workbook.
- Thanks will try and test it out again!