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

Edit in Excel Not Working, Will Not Load Data

(1) Share

Report

Posted on by EH-09052238-0

As of Dec. 8th, the Edit in Excel functionality is no longer working.

When opening any Edit in Excel workbook, the Dynamics 365 Add-in returns this error:
An unexpected app error has occurred. Details: Object doesn't support property or method 'from'

Uploading the file to OneDrive and opening in Excel online similarly returns this error:
An error occurred while writing to the data cache

Details:
An internal error has occurred.

This occurs on both versions 22.5.59966.60134 and 23.1.13431.13546.

Any help is appreciated.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

YUN ZHU 92,762 Super User 2025 Season 2 on at

Like (1)

Report

Edit in Excel Not Working, Will Not Load Data

Hi, I tested BC23.1 and there is indeed a problem. But the error message in my environment is different from yours. I'll check with other users to see if they have this problem.

Error Loading Metadata

Details:
Please check server connection, verify the current user has proper access, and try again. Error message: ''

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Judy Microsoft Employee on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

Hi Sir,

May I know what the office version did you use? Have you tried to update the office version to see if it can help.

What the browser did you use when you get such error, Since the Internal Explore is not supported for the Office Add-in currently.

Best Regards,

Judy

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,762 Super User 2025 Season 2 on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

Update: I checked with others and there is no problem. Data can be updated from Excel to BC.
You can try logging out and logging in again. If using a trial environment, please check your license.

Thanks

ZHU

Was this reply helpful? Yes No
EH-09052238-0 24 on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

Hi Judy,

I am using Chrome. This happens on Firefox as well, and even in incognito mode.
For Excel desktop, I have Excel 2019.

Yun Zhu, I tried logging out and back in (in both the Excel add-in and my browser login), but the issue persists. We are on a paid, premium cloud license, and this happens on both sandbox and production environments.

Thanks,
Erik

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

Erik, this exact error message has been reported. Have you resolved this, if yes what did you do?

Was this reply helpful? Yes No
EH-09052238-0 24 on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

Hi Taiwo, I have not resolved this issue. This issue appeared suddenly with no changes to any of our systems or configurations. I suspect there may have been some change on Microsoft's side that is causing some incompatibility or an error that will require Microsoft's intervention. Thanks for confirming it's not just me.

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

Is there a solution for this? We have similar issue on our end?

Was this reply helpful? Yes No
Community member 3 on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

this is an issue for us too

We have been advised that we should upgrade to Office 2021 (we are on Office 2019) or Microsoft Edge Webview2

but this is not good enough in my view - it needs a proper response

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

We got this error, too.
This error will appear when we use Excel 2016 or Excel 2019, but it's okay to load data when we open version 2021 or open it from OneDrive online.

We hope this issue will be resolved soon cause our users need to use this action.

Was this reply helpful? Yes No
Suggested answer

EH-09052238-0 24 on at

Like (0)

Report

Edit in Excel Not Working, Will Not Load Data

It seems this issue has been fixed in version 23.3. We are no longer receiving any errors in Edit in Excel files. Refreshing and publishing changes are working as expected.

If you are facing this issue, try updating to the latest version of Business Central.

Was this reply helpful? Yes No