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

Edit in Excel not working

(7) Share

Report

Posted on by Hatimali84

564

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 (19)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,428 Super User 2025 Season 2 on at

Like (3)

Report

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 564 on at

Like (3)

Report

I tried to filter it but it also didnt work .

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,190 Super User 2025 Season 2 on at

Like (4)

Report

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 564 on at

Like (4)

Report

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,909 Super User 2025 Season 2 on at

Like (6)

Report

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 95,729 Super User 2025 Season 2 on at

Like (5)

Report

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,230 Most Valuable Professional on at

Like (3)

Report

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 564 on at

Like (4)

Report

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,202 Super User 2025 Season 2 on at

Like (3)

Report

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 564 on at

Like (4)

Report

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

Was this reply helpful? Yes No