Support about using shared excel file in the shared local drive of private company

Question

Please help to support about our current issue: We use Form to input data of root cause analysis sheet and and then press update data, with purpose data will be saved into the Database file ( Excel file ), But when more than 1 users using the Form, for Example 2 user: system cannot save data to the Database file and error " the data base fie is missing" appear. Both the form and Database file we put into the shared drive of our company.

Answer 1

Dear TongZhang,
Thank you so much for your reply to my question.

1. Is this excel file stored in the SharePoint Library? ==> The excel file stored in the local shared drive in our company, not share point.**
2. I'd to send you some more detail about our problem:

Answer 2

Hi @Nguyen Xuan Thuan ,
Did you enable the Shared Workbook feature?
I suggest you refer to this support article about the Share Workbook feature, as the article said this feature has limitations and you can refer to the unsupported features in Shared Workbook:
https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534

What version of Excel are you using?
If you're using the Excel 365, you can try to check if the co-authoring will help you:
https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.