Files opened through Sharepoint or opened through a onedrive shortcut constantly prompt to grant access.

Question

As title states have a user that is complaining about constantly being asked to grant access to open files from sharepoint and onedrive.

Initially fixed when i reinstalled onedrive but came back after a week

Is there a way on mac to grant access to the onedrive or a location permanently the pop up theyre getting is attached.

Havent had complaints from anyone else

any help appreciated

Answer 1

Hi @Zainul Vali ,

You should check the account login in Onedirve and Excel as the same，add OneDrive service to Excel as well.

1. Check the OneDrive account:

How to access OneDrive settings - Microsoft Support

Check the Excel account and add OneDrive service

How to add OneDrive as a service - Microsoft Support

Make sure OneDrive and Excel use the same account ,and OneDrive service added to Excel.

2. Reset OneDrive app setting

To check if the issue related to OneDrive client, try reset OneDrive follow the link and check the result:

Reset OneDrive - Microsoft Support

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

image isnt appearing in edit so adding here