We have a file on a shared drive that is used by 20+ people in our department, not shared for obvious reasons, so the gereral rule is only to access with write access when required, and get out as soon as you finish.
On Friday we came accross a problem whereby excel was reporting that a colleague was in the file with write access, but she was not. We tried all the usual things, closing excel, rebooting..... no joy. Even she was unable to write to the file, as she was also being told that she was already in it. This lasted several hours before our unhelpful helpdesk managed to clear it, but I would like to get to grips with the cause.
This is not the first time that this has occured, but the footprint usually clears itself after a reboot.
Any ideas as to the cause and how one would normally go about clearing it?
I tried saving the file as something else and then saving over the old file without success.
Excel 2002 - User in file
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Excel 2002 - User in file
Nathan
There's no place like home.....
There's no place like home.....
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel 2002 - User in file
If it's on a network drive, there's probably not much you can do about it. The network admin should look into it, perhaps there's a setting that keeps files locked longer than necessary. The network admin is also the only one who can manually unlock a file on a network drive, I believe.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 12577
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Excel 2002 - User in file
On the serving computer you can right click on My Computer and choose Manage, then expand Shared Folders in the left pane and select Open Files.
This should show which computer has the file open, and you can right click the file and choose "Close open file" to force it to close.
This should show which computer has the file open, and you can right click the file and choose "Close open file" to force it to close.
StuartR
-
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: Excel 2002 - User in file
Alternatively, the user might have the file still open in a hidden instance of Excel, check task manager.
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Re: Excel 2002 - User in file
Thanks all. Hopefully this won't happen again, but it certainly a pain when it does!
Nathan
There's no place like home.....
There's no place like home.....