Comments
>1. In which scenarios is it not desirable for users to have access to "Edit in Excel"?
For example in case of a not very clever user, they can accidently delete maybe one customer, but though Edit in Excel they can easily delete ALL customers, just by removing "non-interesting" (according to their thinking) lines from excel.
That's why we should have different permissions for "Open in excel" and "Edit in excel", so that editing is possible to advances (with higher IT IQ) users and opening in excel for all users (in finance department for example).
>2. Have you tried denying write access to the appropriate tables which you do not want edited in Excel?
They should be able to delete a single record but not all.
Category: Office Integration
Business Central Team (administrator)