Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Dynamics Excel Add-in is not Working

Posted on by 30

Hi

For security reasons, we don't want our users to download or have access to the Microsoft Store site to download Add-ins. We are currently trying to implement Dynamics AX to transfer data to Excel utilizing Admin managed add in Microsoft Dynamics. What we are finding is that when users attempt to run a Dynamics report using the web browser functionality of “open lines in Excel” the Admin Managed Dynamics AX add-in does not load and generates an error. "Microsoft 365 has been configured to prevent individual acquisition and execution's of Office Store Add ins", which correspond with the admin managed settings since we are not using Dynamics 365 from the Microsoft Store, again, due to security reasons. Our question is, can we utilize Dynamics AX to mimic the functionality of Dynamics 365, as an add-in in excel to achieve the financial team goal? Any help will be appreciated. 

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Dynamics Excel Add-in is not Working

    Thanks for sharing the solution, Cesar. I have marked your reply as verified to set the status of this question to 'Answered'.

  • Verified answer
    Cesar S. Profile Picture
    Cesar S. 30 on at
    RE: Dynamics Excel Add-in is not Working

    We  had received information from Microsoft. 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

    Doing this, fixed the problem.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Dynamics Excel Add-in is not Working

    Hi Cesar,

    Are you using Dynamics AX 2012 or Dynamics 365 Finance and Operations? You are using both Dynamics AX and Dynamics 365 in one question which leads to this confusion.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans