I'm having trouble with Excel fairly frequently saying that the workbook I'm trying to open is locked for editing by "another user" or "jmichael" (which is me).
Now in none of these instances did I have the file open (on any machine, nor in background). In some cases I won't have touched the file for weeks. What I suspect is that the ownership isn't being released properly when I close the file. I base that on the fact that A) if I open read-only, close the window, and then re-open, I get no such warning; B) it seems to happen more with files closed via macro.
I was hoping someone might be able to provide guidance on what might be causing this. I'm running Excel 2013 in Win7. If it matters, it's a virtual machine (I've run like this on a more limited basis at prior employers with no issue, but would believe I just hadn't done so enough to hit this case). As mentioned above, I have a way to clear the fake ownership, I'd just like to fix (or get IT to fix) whatever is causing the issue in the first place.
Thanks!
1 Answer
Turn off the Details Pane in Windows Explorer.
Open Windows Explorer
Click Organize (top left under the File menu)
Click Layout
Click Details Pane
The Details Pane gathers information about the file and while doing so, puts a "lock" on it.
1
