Comments
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
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team