By workbook, do you mean an Airtable base?
Yes, multiple can work in the same Airtable base at the same time. You can even work in the same Airtable base yourself in multiple windows or devices. (I actually do this a lot.)
If someone else changes a value in a grid view that you are in, you will see immediately that the other person made the change.