A few of my users are in and out of various Excel 2007 spreadsheets all day. One of them reports that "50% of the time" she tries to open a spreadsheet from the file server, an information message comes up stating:
foo.xlsx is locked for editing
by 'another user'.
Open "Read-Only" or click "Notify" to open read-only and receive notification
when the document is no longer in use.
Nine times out of ten the document is not open by another user. My users immediately try to open the same document again, and it works.
I imagine this is caused by Excel leaving owner files on the server, but I do not know why.
An added clue: When one of my users selects "Notify," a dialog pops up in a moment informing them the file is available for them to edit.
Any guidance on how to solve this issue and make my users' days flow better?