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

Edit in excel error

(7) Share

Report

Posted on by CU13010319-0

458

User already has the Edit in excel - admin and edit in excel - view permission sets. After clicking edit in excel, the excel sheet opens up, but the function including new, publish, etc do not appear. Instead, a message appears: add-in information: Microsoft 365 has been configured to prevent individual acquisition and execution of Office Store Add-ins. In the Microsoft 365 admin center, settings, I enabled the let users access the office store. That toggled on enabled another user who had the same error to then use edit in excel. Any ideas how to let edit in excel be permissible for this particular user?

Categories:

Dynamics 365 Business Central

Edit in excel err...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (3)

Report

May this can help : https://learn.microsoft.com/en-us/answers/questions/5031705/sorry-office-365-has-been-configured-to-prevent-in

https://community.fabric.microsoft.com/t5/Desktop/Microsoft-365-has-been-configured-to-prevent-individual/td-p/3632593

https://windowsreport.com/microsoft-365-configured-to-prevent-individual-acquisition-of-office-add-ins/

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,907 Super User 2025 Season 2 on at

Like (5)

Report

Hello @CU13010319-0,

The issue occurs because the Office Add-in required for Edit in Excel is blocked by Microsoft 365 admin policies for that specific user. Even though you've enabled Let users access the Office Store, the user might still be restricted by a custom policy or group-based assignment that overrides the global setting. To resolve it, go to Microsoft 365 Admin Center > Settings > Org Settings > User owned apps and services, and ensure that Let users install Office Add-ins is enabled for the user's group. Also, check Integrated Apps settings and verify that the Microsoft Dynamics Office Add-in is not blocked. If needed, assign the add-in directly via Integrated Apps > Deploy Add-in.

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

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

Please try to see if it works in your browser first.

More details: Dynamics 365 Business Central: How to use Edit in Excel in the browser/web (Excel Online)

https://yzhums.com/39161/

This may be due to your local Excel not allowing the installation of add-ins, or other local group policies.

Hope this can give you some hints as well.

Thanks.

ZHU

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

Like (3)

Report

Hi, good day
I hope this can help you, and give you some hints.

Dynamics Office addin issues

Solved: Dynamics Excel Add-in is not Working

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (2)

Report
Hello,

Regarding the issue reported with the "Edit in Excel" functionality in Business Central, although the user has the correct permission sets assigned, the error message indicates that Microsoft 365 is configured to block individual acquisition and execution of Office Store add-ins.

In addition to enabling the setting "Let users access the Office Store" in the Microsoft 365 admin center, it is recommended to verify the following:

Microsoft 365 Policies
Access the admin portal and ensure there are no tenant-wide or group-specific restrictions on the use of Office add-ins. In particular:

Go to Settings > Integrated Apps > Office Add-ins and confirm that users are allowed to install and run add-ins.

Under Settings > Org Settings > Services, check that the option "Let users install Office add-ins" is enabled.

Excel Version
Confirm that the user is working with a supported version of Excel (preferably Microsoft 365 desktop). Outdated or standalone versions may not fully support the Business Central add-in.

Office Cache
In some cases, local cache may interfere with the add-in loading. It is advisable to clear the cache by deleting the contents of the following folder:

%LOCALAPPDATA%\Microsoft\Office\16.0\Wef

Testing with Another User or Device
To rule out issues related to the user profile or device, test the same account on a different machine or a different account on the same machine.

Reassigning Permissions
In some cases, removing and reassigning the Edit in Excel – Admin and Edit in Excel – View permission sets can help refresh the user’s effective permissions.

I hope these suggestions prove helpful.
If the issue is resolved, please consider marking this response as accepted so it may assist others facing the same problem.

Kind regards.

DAnele

Was this reply helpful? Yes No
Akash Raj 121 on at

Like (3)

Report

Hi @CU13010319-0,

You might find this blog helpful in resolving the issue: https://yzhums.com/39161/

It provides a clear walkthrough that could point you in the right direction.

Let me know if it helps!

Regards,

Akash Raj

Was this reply helpful? Yes No
Suggested answer

Sahib Dino 196 on at

Like (2)

Report

Edit in Excel feature in Dynamics 365 Business Central involves enabling browser-based editing through Excel Online. By integrating OneDrive, users can seamlessly open editable Excel files right in the browser—avoiding local add-in limitations.

This approach also helps troubleshoot problems where the Dynamics Office Add-in is missing or fails to load. Manual installation steps and permission checks are key to restoring full functionality.

If this answer help you please make this answer verify

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (2)

Report
Hi,

The issue you’re seeing is tied to how the Microsoft Dynamics Office Add-in is deployed and whether the user is allowed to acquire it individually.

Even if the user has the correct permission sets (Edit in Excel – Admin and View), the Excel sheet won’t show the Publish or New buttons unless the add-in is properly installed and activated. The message you’re seeing:

“Microsoft 365 has been configured to prevent individual acquisition and execution of Office Store Add-ins”

means that centralized deployment hasn’t been configured, and individual acquisition is blocked by policy. Toggling “Let users access the Office Store” in the Microsoft 365 admin center is the right move — but it only works if the user is allowed to install add-ins manually.

To fix this for the affected user:

Go to the Microsoft 365 admin center → Integrated Apps

Use Centralized Deployment to assign the Microsoft Dynamics Office Add-in to the user directly

Alternatively, have the user open Excel → go to Insert > Add-ins > Store → search for “Microsoft Dynamics Office Add-in” and install it manually (if policy allows)

Once the add-in is installed, the Edit in Excel pane should appear with full functionality. If switching between deployment methods, note that previously created Excel files may not work until the add-in is reinstalled.

Helpful References:
Getting the BC add-in for Excel – Microsoft Learn
Edit in Excel Not Working – Dynamics Community
How to allow Open in Excel but not Edit – Dynamics Community

If you find this helpful, feel free to mark this as the suggested or verified answer

Cheers
Jeffrey

Was this reply helpful? Yes No