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

Edit in Excel not working

(10) Share

Report

Posted on by Hatimali84

663

Hi All,

I am having an issue with Edit in Excel option in Business Central. On users page, I am doing "Edit in Excel", it opens the excel, connects and refreshes the data and after 5 minutes or more, it gives an error message.

Other pages are working fine but only the users page is giving error.

I checked in sandbox and its working there but not in Production.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (20)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi @Hatimali84,

I think this typically happens due to Timeouts from the OData connection (Excel uses OData).

Try to add a filters and then retry.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Hatimali84 663 on at

Like (4)

Report
Copy link

Link copied!

I tried to filter it but it also didnt work .

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 5,166 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Hello,

You could validate with this option to have more detail:

Open Excel → Go to File > Options > Advanced
Scroll to General > Enable logging for Office Add-ins

Reproduce the issue, then gather the log file for support or troubleshooting.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Hatimali84 663 on at

Like (5)

Report
Copy link

Link copied!

Hi @Andrés Arias

I tried this as well but didnt get any results.

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,951 Super User 2026 Season 1 on at

Like (6)

Report
Copy link

Link copied!

Hello,

Verify that the Excel Add-in and OData settings are consistent across environments. Additionally also check is there any permission restrictions or customizations affecting the Users table.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

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

Like (5)

Report
Copy link

Link copied!

Can reopening this Excel file solve the problem?

Also, will this problem occur when using Edit in Excel in the browser?

More details: How to use Edit in Excel in the browser/web (Excel Online)

https://yzhums.com/39161/

Thanks.

ZHU

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

Like (4)

Report
Copy link

Link copied!

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

Edit in Excel limit reached-Increase refresh limit

Best Regards
Gerardo

Was this reply helpful? Yes No
Hatimali84 663 on at

Like (5)

Report
Copy link

Link copied!

Hi All,

We tried everything and it still does not work,. Now we are trying to work with Microsoft to get this fixed.

Thanks for all the suggestions

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,210 Moderator on at

Like (4)

Report
Copy link

Link copied!

How many users need to be loaded in this page? It should work if other pages work fine. Try this another time and see if it makes any difference.

Was this reply helpful? Yes No
Hatimali84 663 on at

Like (5)

Report
Copy link

Link copied!

@Jun Wang we have tried many different ways but for some reason it does not work.

Was this reply helpful? Yes No