Excel File Locked Out By Self

We are having an issue with an excel file on a network drive, where a user opens an excel workbook 'stats.xls', closes out of it, tries to reopen the file and gets

It is locked out for all other users trying to access it also.
We have tried deleting Temp folders in both Windows folder and local users folder.
Also there are no temp files (~$stats.xls) remaining in the files folder.
We have found that the file appears to unlock itself automatically after a certain period of time(maybe 1-2Hrs).
Is there a solution to this problem other than having to wait for it to unlock?
Holl_ITSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lisaraoCommented:
There are many facing this issue, but there is a workaround, just try

   1. Click Start, and then click Run.
    2. In the Open box, type regedit, and then press ENTER.
    3. In Registry Editor, locate the following subkey in the registry:
    4. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet \Services\LanmanServer\Parameters
    5. In the right pane, click EnableOplocks, and then press ENTER.
    6. In the Value data box, type 0, and then press ENTER.
    7. Quit Registry Editor.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EirmanChief Operations ManagerCommented:
This free file unlocking utility is a must have on every system. I've been using it for many years and have unlocked hundreds of files with it (and found out what process was causing the problem).
http://www.emptyloop.com/unlocker/
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.