News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Business Central W1 on...

Business Central forum

Suggested answer

Business Central W1 on prem - Excel Add In

(0) Share

Report

Report

Posted on by TB-06050451-0

2

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:

Integration with Dynamics 365 products

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Ben Baxter 4,486 Super User 2024 Season 2 on at

Like (0)

Report

Business Central W1 on prem - Excel Add In

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
Suggested answer

YUN ZHU 68,664 Super User 2024 Season 2 on at

Like (0)

Report

Business Central W1 on prem - Excel Add In

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2

Martin Dráb 228,177 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans