I have created an timesheet application from scratch with excel table as database(one drive). We have 30+ users using the same application. In order to achieve viewing the records from the table of excel and adding entries to the table of excel, given full access to all users.
Now the problem is, any user(who has access to the file) can modify the entries in excel file of other users or his own entries if he can find the Data storage Excel stored in onedrive which is not acceptable.
Do we have any solution to let users can Add entries and view the entries from the same table of excel without modifying the data.