Forum Discussion

noorulahmed's avatar
noorulahmed
Copper Contributor
Aug 05, 2024

Error opening Excel documents stored in SharePoint Subscription Edition MySite using excel app

Hi There,

Recently, we migrated the MySites from Sharepoint 2019 to Sharepoint Subscription Edition. We created new Managed Metadata Service, User Profile Service, Search service application, new Web application on the SE environment. Then, we migrated the content databases from SP 2019 to SE edition and mounted to the web application. We had 1500 users, but out of them three cannot open the excel files stored in their OneDrive using Excel application. They get the message "Access Denied. Contact your administrator" error when they try to open the file. However, they can open the same file using Excel Online connected with Office Online Server. So far, we have unlink their OneDrive client, and relinked them, deleted their MySite and created again using the MySiteHost auto site creation, but still the issue remains. The only change that we see is that their OU in the active directory changed, as compared in their User Profiles in UPS in both environments. When the administrator logs into their site from their PC, he can edit documents both online and client app based. Kindly suggest any fix to this issue.

 

Regards.

  • noorulahmed's avatar
    noorulahmed
    Copper Contributor
    Additional Information: The user is able to open the Excel file in Excel App as read-only but not able to edit it. The user is the owner of the file and the site administrator of his MySite site.

Resources