Forum Discussion
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...
Hi Konrad
I will assume that Sheet means that they are stored in a Workbook in this instance.
In my understanding, you cannot grant access to sheets B-F as they are owned by someone else. The owner would need to grant access to those workbooks via OneDrive permissions for B-F to work.
I hope that makes sense.
Good luck!
Cheers
Damien
Thank you, Damien!
Well, my problem is that my colleague (owner of sheet B-F) and me don't want to give the other colleague full access to sheets B-F. I'd just like to give access to the very data that is accessed by sheet A.
I wondered if there was a way of telling Excel to get that data without full access to the original sheets...
- Hi Konrad
I don't think there is a way to give selective access like that (at least that I am aware of).
You would have to grant access to the whole file to link to the sheets with the data.
Maybe of the other experts here has more info on this but I am not aware of a way to do it.
I do hope that it works out well for you Konrad!
Best wishes and let me know if you find a solution. I would be happy to learn a new trick!
Cheers
Damien