Small and medium business | Business Central, N...

Cannot open in excel. SharePoint site server error

(6) Share

Report

Posted on by LF-16052033-0

526

Hello experts,

We cannot open in Excel to download a list on any page in Business Central. We are getting an error message saying:

"Could not connect to the SharePoint site. SharePoint Server returned the following error: Could not connect to the following SharePoint site: 'https://mycompanyinc-my.sharepoint.com/'. SharePoint Server returned the following error: 'Attempted to perform an unauthorized operation.'."

Do you know how to fix this? I believe we had BC permissions before. Are there SharePoint issues? I thought all files get stored in OneDrive?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Don’t you have a Microsoft 365 license?

I'm not sure if it's related, you can try disabling the following option first.

In addition, this may also be a problem caused by customization. It is recommended that you contact your partner directly.

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (1)

Report

Hi

To add some more information

Opening Business Central Files in OneDrive - Business Central | Microsoft Learn

Best

Gr

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 3,950 on at

Like (0)

Report

Namaste @LF-16052033-0

Check the addin excel

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-deploy-excel-addin

https://learn.microsoft.com/en-us/microsoft-365/admin/manage/manage-addins-in-the-admin-center?view=o365-worldwide

Check permission sets of user

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 4,836 on at

Like (5)

Report

Hi

This error occurs when the Business Central–SharePoint/OneDrive connection is broken or permissions are missing. To fix:

➡ Check that the user has Edit permissions on the SharePoint/OneDrive site.

➡ In BC, go to OneDrive Setup and reconnect if expired.

➡ Confirm the user’s Microsoft 365 license includes SharePoint Online + OneDrive.

➡ Ask your admin to grant Admin consent in Azure AD for Business Central.

➡ If issue persists, delete and reconfigure the OneDrive connection in BC.

After reconnecting and ensuring permissions, Open in Excel will work again.

Thanks

Nimsara

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,150 on at

Like (4)

Report

Hi,

This error usually happens because the OneDrive/SharePoint connection for Business Central is no longer authorized.
Fix:
> Go to My Settings > OneDrive Setup in Business Central.
> Re-run the OneDrive connection wizard and sign in with your Microsoft 365 account.
> Ensure your user has a valid SharePoint/OneDrive license and access to the company SharePoint site.
> After reconnecting, try Open in Excel again.

If the issue persists, ask your admin to reauthorize the Business Central app in Azure AD and verify that the SharePoint site URL in BC’s OneDrive Setup matches your tenant.

Thanks

Rishabh

Was this reply helpful? Yes No