"Access denied. Contact your administrator" - Excel cannot be opened from Share Point Online

Question

_{Wednesday, February 19, 2020 2:21 PM}

One colleague at my work has a problem with Excel. The problem is: he is on Share Point Online, he opens Excel file in online mode/version, he chooses an option "Open in desktop app" and he receives a message "Access denied. Contact your administrator". The same problem is with Word. What can be done about this? How could this problem be fixed? He uses Windows 10 Pro (64-bit), Office 365 (64-bit), Excel 2016.

All replies (3)

_{Wednesday, February 19, 2020 4:31 PM}

Hi 

May i know if the two files in the same folder, or different folder?
Did you try to use different account login to PC and see if it works?

Please refer below link to check:

/en-us/sharepoint/troubleshoot/administration/access-denied-or-need-permission-error-sharepoint-online-or-onedrive-for-business

_{Thursday, February 20, 2020 2:21 AM | 1 vote}

Hi, lgiBG,

Please first check the account user uses in Excel 2016. Try with the following steps. 

1. Open a blank Excel file, go to File > Account > Sign out > In the “Remove Account” pop-up window, Click “Yes” --> your account will be removed from Excel and now close the excel file.

2. Again open the office file with the option "Open in desktop app". If you get a Excel Sign-in pop-up. Sign-in using your Id and click “Next”. 

If this does not help, try to download the file to the user's PC and open it with Excel 2016. See if the issue persists. 

And would you like to check if this issue occurs on other users and files in other locations inside your SharePoint site? Also please check with other PCs.

Best Regards

Jerry

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click here to download it.
Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

_{Monday, February 24, 2020 9:06 AM}

Hi, lgiBG,

Is there any update in these days? Have you tried the fix?

Best Regards

Jerry

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.