How to get full access in excel file in shared network?

My fellow workers and I are experiencing a problem with a Microsoft Excel sheet that is shared through our Network drive.
Full access to that Excel sheet was given to all 10 users to and we have also enable the Share Workbook option to allow more people to work on that workbook at the same time.
The problem is out of 10 users with full access, only six of them are able to work on the workbook.
The remaining four users would receive the error message saying “Recover my data and restart Microsoft Office Excel”.
I am hoping you’ll be able to help us identify the problem and to find a solution. Thank you.
