Read only mode if workbook is already opened

[Oprichnick]

Hello,
Me and my colleagues have several workbooks in a shared environment (Druva in sync).

We have some problems with conflict / duplicates files that are generated when more than one user open the same file and edit it.

I'm aware that there are some vba solutions for this issue.

However, as my colleagues are not skilled in vba and files are added and removed for in sync quite frequently, is there a solution more simple than vba? Like box ticking?

The best solution would be further openings to be in read-only. I believe...

I tried "share workbook" but that didn't solve the problem.

Thanks,
Pedro