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

Edit in Excel Error

(0) Share

Report

Posted on by Capt Jon

The edit in Excel feature has been bumpy at best. It wont work from my laptop. It used to only work from my terminal server, but then it started working outside the terminal server and from my home desktop. All of my logins are from the same account so I dont see why there would be any differences. Now it is broken again even in the terminal server with this error:

An error occurred while retrieving the row count of entity Item_Card_Excel. Error details: The OData filter expression is not supported. CorrelationId: c6d75fa1-5492-4676-93cd-87c0fbc69798.

I am running BC 19.4 in the cloud.

Any suggestions?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

Can you please check this blog post and follow the steps? Looks like somehow your user or your environment has one the described issue in this article.

If you already done these steps please let us know.

olisterr.blogspot.com/.../how-to-resolve-edit-in-excel-issues.html

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I have had some situation where different security policies on my computer have prevented me from using the edit in Excel function.

So it can be a good idea to ask your IT department for a list of the policies they apply to your laptop and/ or your terminal server and check if some of them potentially can interfere with the Excel functionality.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, Is it possible that the two PCs you are using have different languages?

From the error message, the OdataFilter here did not get the correct value.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No