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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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... / ADD-IN ERROR You don...
Small and medium business | Business Central, N...
Suggested Answer

ADD-IN ERROR You don't have permissions to use this add-in.

(6) ShareShare
ReportReport
Posted on by Dynamics and Beyond 126
 
 
All users are reporting the above message when attempting to use " Edit in Excel " anywhere within Business Central v26.4 with Excel 365 while " Open in Excel " works fine.  This is for an environment which all the same users were previously able to do without issue.  No changes to BC, Office or Windows including browsers are known to occur.   Reviewing online content, many articles involve setup however this was a working environment already setup.
 
What situations are known to cause the above error to display for an already configured environment?   What permissions is it referring to? 
Categories:
Dynamics 365 Business Central
I have the same question (2)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,423 Super User 2026 Season 1 on at

    Hi there,

    Thanks for sharing the issue. The error you're encountering with "Edit in Excel" in Business Central v26.4 typically relates to Office add-in permissions or authentication issues, even in previously working environments.

    Here are a few things to check:

    1. Office Add-in Permissions

    • Ensure that the Excel add-in for Business Central is still enabled in the Office 365 admin center.
    • Users may need to have "ReadWrite" permissions for the add-in to function properly.

    2. Azure AD Authentication

    • Sometimes, token or session issues can cause this error. Try clearing browser cache, signing out, and signing back in.
    • Make sure users are properly authenticated via Azure Active Directory.

    3. Excel Trust Center Settings

    • Open Excel > File > Options > Trust Center > Trust Center Settings.
    • Check that add-ins are not disabled and that protected view settings are not interfering.

    4. Role and Permission Sets in BC

    • Even if no changes were made, verify that users still have the "Excel Export Action" permission set or equivalent.
    • Check if any environment-level security policies have changed.

    5. Browser and Office Updates

    • Although you mentioned no updates occurred, it’s worth checking for pending Office updates or browser extensions that might block add-in functionality.

    Let me know if this helps, and please mark the response as helpful if it solved your issue 😊

    Best regards!

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,787 Super User 2026 Season 1 on at
    Hi, This appears to be a local Excel policy issue. You can try the following browser versions to see if it works.
    Then consult your local administrator.
    Dynamics 365 Business Central: How to use Edit in Excel in the browser/web (Excel Online)
     
    Thanks.
    ZHU
  • Suggested answer
    Andrés Arias Profile Picture
    Andrés Arias 5,192 Super User 2026 Season 1 on at
    Hello, 
     
    I hope the following information can help you:

    I hope I can help.
     
    Regards,
     
    Andrés
     
     
     
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,177 Super User 2026 Season 1 on at

    This error usually means the Excel add-in lost its permissions or the user only has read rights.

     

    ✔ Re-publish the Microsoft Dynamics Office Add-in from M365 Admin and grant admin consent again in Entra ID.

    ✔ Make sure users have a permission set with Modify rights (Open in Excel = read, Edit in Excel = write).

    ✔ If it still fails, remove/re-add the add-in in Excel.

     

    ✅ Mark this answer as verified if it helps you.

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

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,497 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,778 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,507

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans