How to organize collaboration with a Microsoft Excel document?

Question

excel

30-40 people work with a rather large and relatively complex Microsoft Excel document at the same time, transfer certain values ​​​​from paper to the cells, and certain formulas work on the values ​​​​in the cells. For collaboration, enable "Book Access".

Unfortunately, this functionality works very crookedly, there are permanent file locks, overwriting other people's cells, closing the document without actually saving, five sessions from some users hang in the lists even a day after they close the document, etc. In addition to this, different versions of Microsoft Office are also used, in general, a nightmare, tables are urgent and important.
We tried to transfer the tables themselves to Microsoft Sharepoint, but the work of transferring or creating such tables from scratch is very laborious, some functionality (like formulas) could not be transferred at all. Google Docs and other cloud solutions will not work, the file must be stored on our network, the information is strictly confidential! Thus, in my opinion, the same Office Web Apps for SharePoint + Onedrive will not work, if I'm not mistaken.
Is there a way, software, version control system, technique, whatever, to do this kind of work?

Answer 1

I confirm some glitches:
The rest is not observed, the cells are recorded, saving works. The file is also complex, with different access rights to ranges, etc.
I'm afraid you won't find another option.
Still, something like that, at the level of memories, was when I was looking for options with binary files. That you can both read and write to the file in parts, respectively, to several users at once. But this is if you know VBA well, and you will need to have something like this structure:
But you yourself understand what a huge job it is if your file has a complex structure.

Answer 2

Good afternoon!
Maybe you have come across software that uses Excel as a database, and access is organized as a web?