We are having a issue in which several users have to use the same excel sheet
to add different things and or make revisions but when one of these people
leaves it open the other people can not open it in an editable mode. There
are a couple of people that it will tell which user has the sheet open and
they can go to that person and have them close it. All others just say
different variations of "another user has this open, would you like to open a
copy, or would you like to open it as read only" But there is no way of
telling who it is.

Is there any way to make it display who has it open or to alleviate this
issue that anyone can think of?

Much appreciation in advance!