A client of mine used to be able to see who already had a copy of a spreadsheet open if they attempted to open the same file on the network. But after a recent server upgrade, they were only seeing that someone had it open and not the specific user.
The answer was that someone had saved the file in the newer Excel format xlsx and this ability to be told exactly who else had the file open was lost. The file was resaved as an xls file and now it behaves as before.