In the shared folder where the document is located
1. open the folder where the document is located
2. click tools -> folder options
3. click the view tab
4. select options -> change folder and search options
5. select view scroll down to hide protected operating systems files and uncheck, this will now show hidden system files that are creating the editing lock
6. create a backup of the file by saving to local desktop
7. delete the hidden lock file should look something like ~$filename.xlsx
8. open the file again with the logged in user and verify that they are the correct person accessing the file