I have a shared workbook which seems to work fine sometimes (multiple users
can edit at the same time) but other times when I try to open it I get a
message saying "file is locked for editing. Open as Read-Only".

Why is this happening? How do I fix it?

Thanks