We have an Excel workbook that looks like a database of error codes. Unfortunately, the application is written in the same way as IF (ExceptionCode != AnyPreviousExceptionCode) THEN (Make New Exception Code), which gives a messy problem of new, never seen exception codes appearing in our monitoring software, and requires a group of analysts to investigate. The fact is that this Excel workbook of Error Codes changes day by day, especially if a large release comes out.
The problem is that there is a team that should open this book, since it needs to consult the error code, but there is one person who needs to update this book. Excel, of course, gives full rights to those who open the workbook first, and everyone else should wait, but we have a global team, so don’t just go to someone and tell them: “Please, you can share the book with her” .
Is it possible in Excel to set some users as read-only and other users as write access, and this will affect the graphical interface, so that Excel will not force the user to write to wait until the read-only user closes the book
source
share