Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

'open in Excel' option not working - receiving error message in Excel

(0) ShareShare
ReportReport
Posted on by
Hi there, 
 
I've installed Microsoft Dynamics Office Add-in for Excel and Word. I've configured everything within the add-on, added server URL and was able to load data directly from the add-on.
 
However, the issue arises when I try to open a file from the browser directly to Excel. I get the error message 'Microsoft has been configured to prevent individual acquisition and execution of Office Store Add-ins.' The thing is, the app is enabled and deployed in M365 Admin Center for the affected account.
 
Does anyone know what could be the solution for this? I read that the solution could be to temporarily enable access to the Office Store in the admin center, but that sounds strange if the add-on is already enabled and added to Excel and it works if the data is directly accessed through the add-on. 
 
The issue is opening it from the Browser in Excel. 
 
Thanks!
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    'open in Excel' option not working - receiving error message in Excel
    Hi, for the error messages, please refer to the following document to configure the Add-ins for Office:
     
    Best Regards,
    Judy
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    'open in Excel' option not working - receiving error message in Excel
    Hi,
    Users have asked similar questions before on the forum and got the ending plan, you can refer to these old threads:
    You can try this way:

    To use Centralized Deployment, on the App parameters tab on the Office App Parameters page change the App ID, Store, and Store Type:

    • App ID: 61bcc63f-b860-4280-8280-3e4fb5ea7726

    • Store: EXCatalog

    • Store Type: Centralized Deployment

    Best regards,
    Kevin

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans