web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Dynamics Office addin ...
Small and medium business | Business Central, N...
Suggested Answer

Dynamics Office addin issues

(0) ShareShare
ReportReport
Posted on by PFec 5

We do not allow users to install their own Office Addins from the Office store.  Therefore we have deployed the Microsoft Dynamics Office Add-in centrally so that it appears in the "Admin Managed" addins within Excel (you will see in the below video).

Problem: when a user attempts to use the "edit in excel" feature they are presented with the "Microsoft 365 has been configured to prevent individual acquisition and execution of office store add-ins.

It is as though the addin expected within the template from BC is different somehow to the one installed and therefore attempts to reinstall it.  Or the template does not know to look for the addin in the "admin managed" section.

I would really appreciate your assistance on this as the current solution is not efficient for our users.

pastedimage1623751316917v1.png


[View:/cfs-file/__key/communityserver-discussions-components-files/758/Excel-addin-issues.MP4:1440:1080]

I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at

    Hello - You will get this error if you have a Centralized deployment of the Office add-in and the new user has not accessed the Microsoft Store for this addin prior to this option being enabled in the Microsoft 365 Admin Center.  The only way to workaround this message is to temporarily enable the option for 'Let users access the Office Store' and have the users run Edit in Excel to download the app.  After the user has the app downloaded the store can be disabled.

    The app is a shared app that was developed by our AX development.  When AX encountered this issue, they implemented the Centralized Deployment version as a separate add-in with the same name/endpoint/functionality. When we generate the workbook, we need to match the add-in that was deployed - either the Centralized Deployment version or the standard version.

    Currently we only support the standard add-in from the 'Edit in Excel' button, this is set in AL code and future features are being discussed to determine how we can allow use of either the standard or Centralized Deployment models from within the 'Edit in Excel' button directly.

    I know this is not ideal, but would be our only workaround until they change the functionality of the app.

  • Eric_Kurtz Profile Picture
    Eric_Kurtz 5 on at

    Has this issue been resolved in Dynamics 365?  I see there is an Office App parameter that lets you set the store type.

      D365-Office-Parameter.jpg

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans