Excel Locked for Editing by Me

After researching many articles online, I am stumped and hope someone can help figure this out.

I am using Excel 2010 on Win 7 and it seems that many users have the same problem.

I saved a file in my network drive and closed it. When I reopened the file two days ago, it said this file is locked for editing by "user(me). Restart/shutdown didn't work.

I closed and I killed excel - even in CMD. I tried a number of things like going to computer management and try finding any opened files however, I can't find any. I tried to even open the file for repair, but same result. I am now downloading an update for excel in hopes it will resolve my issue. Trying to see even through adding HKEY oplocks, but not sure if this will work here.

Thoughts?

Thanks,
Newb

Hello - I followed all your recommendations, but still no luck. Installed CC cleaner, notify, copy/paste/rename and it is still locked by me. I also tried to repair it per the last suggestion given by going to change program>>repair and it didn't work. The version of excel is not an upgrade as I often use this version to create/save workbooks.

Thanks Doverman for doing some digging around. The temp files are located in C:\Users\<username>\AppData\Local\Temp...or there may be another one I am not aware of...but I deleted the tmp files from that folder. I will try another account and see if I can unlock. The HKEY in regedit looks promising, but I would need to create a new key for this. I wish there was a service I could simply stop in computer management. -Newb

Thanks Doverman. I tried with a new account, but didn't resolve the issue. I had to contact the network administrator and he reset the file. Apparently there was a duplicate file holding the primary file hostage! It appears that this problem was due to excel not closing correctly, which caused the clone file.

Thank you to all who gave in your input.

-N

Ok after many hours of going round.

1. If its a network file and you/user has access to the network server to end sessions.
Go to Computer Management > Click Action > Connect to another computer "server where the file is" end the season by you/user

2. If dont have access to the server. Contact your IT and have them put a request in.

The work around is to open the file in read mode only then file save it in the same location but add 2 to the end of the name. Save it.. close and delete the other copy. Rename the one you save with out the 2.

At this time.. there is no secret way to resolve this issue.

My Best solution : Close all Excel workbooks, then Goto Task manager > End All EXCEL.EXE

Originally Posted by newdoverman

From everything that I can find, this problem is related to temporary files not being deleted upon exit from Excel (or other Office program as they can also be affected)

I'm not sure where that folder is.

Folder is C:\Users\<username>\AppData\Roaming\Microsoft\Excel\...
Delete the cache / file and original file will be able to read/write