Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Edit Excel in Business Central

(0) ShareShare
ReportReport
Posted on by 5

Hi

I cannot edit in Excel in the 365 Business Central on the cloud (our Business Central is on cloud). When I opened the 'Edit in Excel', I got an error a message' you don't have permission to use this add-in. Contact your system administrator to request access'. I asked our local IT but they don't know what's wrong and how to fix the error. 

pastedimage1647549724849v1.png

 Error * Add-in Error' 

pastedimage1647549767836v2.png_2D00_640x480.png

Thinh

  • Henrik.aaen Profile Picture
    10 on at
    RE: Edit Excel in Business Central

    We have the same issue that Edit in Excel connection gives error.
    It was working until 22.0 - After tenant upgraded to 22.1 it asked for the Dynamics office add-ins.
    .. this add-in is just not working.

    Other tenants still on 22.0 can still connect!

    I believe its related to BC - This office add-in will need to be added into AD of azure - I did not figure out yet!

  • Suggested answer
    YUN ZHU Profile Picture
    85,289 Super User 2025 Season 1 on at
    RE: Edit Excel in Business Central

    Hi,This does not appear to be a BC permission issue.
    I think It's your company's Office 365 security policy that doesn't allow users to install Add-ins for Excel.
    You can try it out by contacting your company's Office 365 administrator.

    In fact, our company has similar restrictions......

    pastedimage1647560994271v1.png

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    MahGah Profile Picture
    15,445 on at
    RE: Edit Excel in Business Central

    Hi

    You need to have all 4 permissions that listed in my screenshot. Can you check for the rest as well?

    Also can you please check this blog post as well

    olisterr.blogspot.com/.../how-to-resolve-edit-in-excel-issues.html

  • Thinh Nguyen Profile Picture
    5 on at
    RE: Edit Excel in Business Central

    Hi,

    I checked in my system, I have access to Edit Excel (see screenshot). but still got an error. Our BC is on cloud. is it something related to the connection?.

    pastedimage1647553993706v1.png

    Thanks

    Thinh

  • Suggested answer
    MahGah Profile Picture
    15,445 on at
    RE: Edit Excel in Business Central

    Hi

    Please check with your system admin to make sure you have the right permission. These are permissions you need. 

    Thanks 

    pastedimage1647551990223v1.png

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans