02-23-2022, 04:35 PM
Hooo... yeah.. nightmare scenario with shared Excel files as a long standing database system.
Oddly.. Office 365 (Cloud Office) may be a possible solution for that.
In addition, you can set up regular save VBA in the spreadsheet. You can also use the validation tools and cell locking tools to keep users from 'breaking' the spreadsheet. I've done all that crap in the past. Fortunately now I just get to use big 'ol database engines and don't use Excel as a database / application environment any more.
Oddly.. Office 365 (Cloud Office) may be a possible solution for that.
In addition, you can set up regular save VBA in the spreadsheet. You can also use the validation tools and cell locking tools to keep users from 'breaking' the spreadsheet. I've done all that crap in the past. Fortunately now I just get to use big 'ol database engines and don't use Excel as a database / application environment any more.