In my current system I have one Excel file where the user interacts through forms and data are written to a hidden sheet mimicking a database.
Conversely whenever a sheet is opened it is populated with data from the hidden sheets. All cells are locked for editing, every user input is through a...