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

Using Edit in Excel functionality as a guest user

(1) Share

Report

Posted on by AntonioKD

432

Hello Experts,

In my installation users are created as a guests (because they have gmail instead of outlook).
Is there any possibility for them to use Edit in Excel functionality being guests instead of full users in tenant?

Thank you in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

Please, can you clarify what you mean guest user, are you in an onprem or saas version?
If you are on onprem, please check this out.

Setting up the Excel Add-In for Editing Data - Business Central | Microsoft Learn
If you are in saas, this

Viewing and Editing in Excel From Business Central (contains video) - Business Central | Microsoft Learn

BR

GR

Was this reply helpful? Yes No
Suggested answer

Dynamics_Decoded_Gokul 487 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Please take a look at the comments from Microsoft Learn. Edit in Excel requires access to your Business Central license if the external user has a license to Business Central and then they can use edit in Excel by login into Excel

Thanks
Gokul

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,208 Moderator on at

Like (1)

Report
Copy link

Link copied!

first you need to find out the license type of the guest user. If it is team license, then it might not be allowed to edit in excel.

second, check if excel BC addin has been properly installed/deployed.

Jun Wang

Was this reply helpful? Yes No
AntonioKD 432 on at

Like (0)

Report
Copy link

Link copied!

Hello everyone who answered!

I am talking about SaaS version and guest users with gmail - not external accoutntant. They will have Essential licesne. I still don't know if they will be able to use edit in excel function? :(

Was this reply helpful? Yes No