18
Allow Edit in excel to delegate admin this is needed for implementation , training , analysis etc..
STATUS DETAILS
Planned
2022 Release Wave 2
Ideas Administrator

Thank you for your valuable feedback. We have decided to deliver this idea and make it available with Business Central 2022 release wave 2.  

"Delegated admins can edit in Excel"

Learn more about what's new in the release plan here: 

Your help was greatly appreciated,  
Mike Borg Cardona
Program Manager at Microsoft 

Comments

G

We received an official response:
>In regards to your support request and my previews email.
>I have confirmed with the back-end team that this is an expected system behavior and edit in excel will not work for external admin / partner.
>This reference is an official Microsoft statement on your current scenario.

Cmon Microsoft.
With the arrival on BC15 in october 2019 we (external admin / partner) got the possibility to Edit in Excel.
For whatever reason Micosoft has taken this right away AGAIN (I remember I was able to use Edit In Excel with my external admin / partner account in spring/summer 2020).

If not possible in Production environment (for whatever user rights restrictions), then at least we should be able to use Edit In Excel in Sandbox (to show customer how it works).

Better yet - let users with external admin / partner accounts Edit In Excel in Sandbox AND Production ... because we can always manipulate data with configuration packages ... so there is no difference in end result just more PAIN in the process.

Category: Office Integration