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

Business Central SaaS Updated to 19.0 the Excel Add In stopped functioning

(0) Share

Report

Posted on by eaf-joseph

The Exel Addin has stopped functioning on version 19 of BC after it was updated for us yesterday.

Any attempt to open something/edit in excel sees the error "unable to load metadata for the entity."

Anyone else experiencing this? Is this system-wide? Anything we could try?

Thanks

I have the same question (0)

All responses (9)

Answers (0)

eaf-joseph 42 on at

Like (0)

Report

Follow up post with screenshot of the error in Excel.

Was this reply helpful? Yes No
Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

It is working fine in the installations i have testet it on. But this is a feature that can be controlled with the D-365 Excel exporthandling permission. Are you sure you have that permission in your enviornment?

Was this reply helpful? Yes No
eaf-joseph 42 on at

Like (0)

Report

The users have this. The issue seems to be intermittent. It allows them occasionally, then it swaps back to not working.

Regards

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

Then i will advice you to open a support ticket with Microsoft through your CPS partner. It could be an issue with your Business Central tenant.

Was this reply helpful? Yes No
eaf-joseph 42 on at

Like (0)

Report

We have done that as well. Thanks. Was posting here for visibility and potential quick fixes if it was not tenant-related, but this is what we have also thought. Thanks for taking the time.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, this seems to be related to this update.

https://yzhums.com/18132/

Was this reply helpful? Yes No
daniel.underwood 40 on at

Like (0)

Report

We have a similar issue. For us after the update, we no longer see the option to Edit in Excel on our journal screens in BC. The options seems to have disappeared after the update and no other changes or permissions have been edited. Annoying!

Was this reply helpful? Yes No
eaf-joseph 42 on at

Like (2)

Report

The icon is on the right side and is the share icon. It opens up a menu to do what you are looking for. Open in Excel, Edit in Excel, etc...

As for the issue, with Microsoft report we did:

If you have the issue again, two things to try:

1. Clear the query cache in Excel. Then close/restart Excel.

support.biconnector.com/support/solutions/articles/8000086739-how-to-clear-query-cac…

2. Close Excel. Open Business Central and Edit the Customet List via Excel. You do not have to publish anything but loading an external sheet outside of the journals seems to trigger correct functionality. Once the data loads, you can close it and try a Journal.

Hope this helps others.

Was this reply helpful? Yes No
daniel.underwood 40 on at

Like (0)

Report

Thank you so much for the quick reply. Such a simple thing and it stumped our whole team. All the best

Was this reply helpful? Yes No