Aug 02 2018 12:22 AM
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!
Aug 02 2018 12:54 AM - edited Aug 02 2018 12:54 AM
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
Aug 02 2018 12:59 AM
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...
Aug 02 2018 01:06 AM
Nov 18 2021 08:17 PM
Nov 18 2021 11:09 PM
@Marconi Poveda No, I gave up on this ;)
Jul 07 2023 09:43 AM