Excel data link without permission in Sharepoint
Good morning, please excuse if the terms I use are not correct, Excel is not running in English, so all terms I use are translated. I've got an Excel sheet with some data links to other Excel sheets. Let's call this sheet A. I access the other sheets (let's call them sheets B-F) via sharepoint, they're shared by a colleague via onedrive. Now I shared my sheet A with a third colleague, works fine. BUT: As the data in sheet A should be automatically updated from sheets B-F, the latter colleague is asked to sign in with another account, because he has no access to sheets B-F. Can I somehow give access to the relevant data of sheets B-F for each user of sheet A without giving them access to whole files? Thanks in advance for your help!