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 / Small and medium business | Business Central, N... / Edit Excel in Business...
Small and medium business | Business Central, N...
Suggested answer

Edit Excel in Business Central

(0) ShareShare
ReportReport
Posted on by Thinh Nguyen 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

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 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

  • Thinh Nguyen Profile Picture
    Thinh Nguyen 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
    MahGah 15,529 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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 93,222 Super User 2025 Season 2 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

  • Henrik.aaen Profile Picture
    Henrik.aaen 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!

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,828

#2
Sumit Singh Profile Picture

Sumit Singh 2,617

#3
YUN ZHU Profile Picture

YUN ZHU 1,861 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans