Small and medium business | Business Central, N...

Business Central W1 on prem - Excel Add In

(0) Share

Report

Posted on by TB-06050451-0

Hi

We are looking into a business central installation for W1, the client wants to know if they can edit a journal in excel, like in the SaaS version of BC.
Is that functionality available for BC W1 version 17

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 99,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes, it is possible, but the setup is quite complicated. Hope the following helps.

Setting up the Business Central Add-in for Excel in Business Central On-premises:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/configuring-excel-addin?wt.mc_id=DX-MVP-5004336

However, please note that BC17 has been end of support, please upgrade to the latest version as soon as possible.

https://learn.microsoft.com/en-us/lifecycle/products/dynamics-365-business-central-onpremises-modern-policy?wt.mc_id=DX-MVP-5004336

Thanks.
ZHU

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,918 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes, but the on-premise version is going to require an Azure AD Replication (now called Entra ID) setup to be completed. Once you complete that the office integration should function about the same.

Here is the link to Microsoft Learn: Setting up the Excel Add-In for Editing Data - Business Central | Microsoft Learn

P.S. I don't think you'll be able to license version 17, nor would you want to.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No

Join the conversation

Community site session details

Business Central W1 on prem - Excel Add In

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

Business Central W1 on prem - Excel Add In

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates