As anyone knows if you two users try to access the same excel spreadsheet at the same time when it is not shared you get a popup saying that the spreadsheet is locked for editing by: whoever has it open and an option to open read only, or receive a prompt when they close and such.

I'm having an issue though that the person it says it is locked by isn't the person that has it open. No matter who has it open is says it is locked for editing by John G. does anyone know how to resolve this issue, the customer I'm working with is very frustrated with this. It only does it on this main spreadsheet that they use all the time.

Please assist.