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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / 'open in Excel' option...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by Community member
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!
I have the same question (0)
  • 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 789 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 607 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 497 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans