Currently Open in Excel and Edit in Excel are only available as a complete package, while Open in Excel should be accessible to all users, at the same time Edit in Excel should not be accessible to all users. But at the moment only both or neither is possible.
Comments
Please add asap. User did Edit in Excel not really knowing what they were doing and deleted all GL accounts even though trxs were posted to those accounts. Need to allow Open in Excel on pages and to use Send to Excel for reports for all users, but only allow Edit in Excel permissions to certain users. The permission to edit in excel is included in so many permission sets which needs to be removed and be a separate permission set to assign or not assign to users. Edit in Excel permission set should actually relate to edit in excel feature.
Category: General
To reiterate Peter Frei's comment, it's the difference between a user inadvertently writing bad data to one record and the same user inadvertently writing bad data to thousands of records. You assume all users are as careful and deliberate as programmers and developers. Experience in the real world proves otherwise.
Category: General
Hi Mike, thank you for your reply. The Open in Excel function is very useful. It happens again and again that users need to export data to Excel for further analysis/use. The Edit in Excel function, on the other hand, can be very dangerous as many users are not always aware that the data is written back to BC. Many users with write permission usually only make changes directly in BC. This can limit/avoid unconscious changes. The massive change possibility through the Edit in Excel function, on the other hand, can be very dangerous for "normal" users. So it would be very helpful if you could enable one function independently of the other for users and not either both or nothing.
Category: General
Business Central Team (administrator)