If your excel keeps saying that the documents you are trying to access is opened by another user you can try the following steps to rectify the issue :-
- Open up Windows Explorer (
+ E) - Click on Organise
- Select Layout
- Deselect Details and Preview Pane
Sometimes if you have these selected and you try to open the document excel thinks it is already opened as the preview and details page are accessing information.