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

Edit in Excel feature is not working on user machine

(7) Share

Report

Posted on by AK-12111158-0

Edit in Excel feature is not working on user machine although it is working on my system for same customer for BC online

Data connector window is not appearing to enter login details of user.

what could be the reason

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

TarikJerkovich 293 on at

Like (2)

Report
Copy link

Link copied!

Hello AK-12111158-0,

Your user need to have this permission set EDIT IN EXCEL-ADMIN to be able to use feature Edit in Excel.

In User Card set it.

I hope so this hint solve your issue.

KR

Tarik Jerković

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

The “Edit in Excel” issue usually occurs because the Business Central Excel add-in isn’t installed or enabled, the user is signed into Excel with a different account than their BC account, or pop-up/authentication settings block the Data Connector window.

Other common causes include outdated Excel version, disabled external connections in Trust Center, missing BC permissions, or cached credentials.

Ensuring the add-in is active, signing in with the correct account, updating Excel, and clearing credentials typically resolves the problem.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

The issue is usually related to the Excel Add-in setup or user permissions. Common causes:
> Excel Add-in not installed or disabled

> Pop-up blocker or browser settings

> Office account mismatch

> Add-in blocked by admin policy

> Excel version

If all above are correct, clear browser cache and reinstall the add-in.

Thanks

Rishabh

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

If Edit in Excel doesn’t show the login window on the user’s PC, it’s almost always a local Excel issue, not Business Central.

Common causes:

The Dynamics Office Add-in is missing or disabled

Excel is logged in with the wrong M365 account

Missing/old WebView2

Browser/Excel cache blocking the popup

Add-in corrupted

Fix: reinstall the Dynamics Office Add-in, sign out/in in Excel with the BC user, and clear WebView2/Excel cache.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Hi, Try the following method first, which can rule out problems with your local Excel file.

Dynamics 365 Business Central: How to use Edit in Excel in the browser/web (Excel Online)
https://yzhums.com/39161/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Namaste @AK-12111158-0

Check the Excel Office-Addins Management given by your IT Team .

You can view my answer in this below thread

attaching snapshot

https://community.dynamics.com/forums/thread/details/?threadid=60dcd9b6-9c8e-f011-b4cc-000d3a1ec4ee

Regards

Pallavi Phade

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Getting the Business Central add-in for Excel - Business Central | Microsoft Learn

Edit in Excel not working

Best Regards
Gerardo

Was this reply helpful? Yes No