Locked excel sheets by user who no longer exist

Hello, I have about 6 excel sheets sitting on a shared server on server 2003 that when tried to open they say they are in use and locked by an AD user who no longer exist. I have even tried to delete off the server as an admin and it wont let me because they say they are locked. Same error happens regardless if I try to open in excel 2003 or 2010

Any ideas?
tkthelpdeskAsked:
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.

JohnBusiness Consultant (Owner)Commented:
If you do not need the files (looks like you do not), get Unlocker, install it, right click on the file, select Unlocker and then select Delete. This will normally work.

http://www.emptyloop.com/unlocker/
0
tkthelpdeskAuthor Commented:
That is a good idea, but as I was testing I restored the files to the c drive of the server form back up, I was able to open one of them on the server, I closed it , then waited 10 minutes and tried to open again and now it says it is locked by "admin"
0
JohnBusiness Consultant (Owner)Commented:
A worksheet will not normally lock itself (at least I have not seen that happen).

Do you need the worksheets? If not, delete them.

If you need them, try to open them (as you did), and copy the information and formulas to a brand new workbook. That will allow you to then delete the problem sheet.
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
tkthelpdeskAuthor Commented:
OK I found and fixed the problem, and unlocker helped me by showing me what it was that was locking it.

cidaemon.exe is a process used by server 2003 for indexing. once I killed the task in task manager all is good in the world.
0
JohnBusiness Consultant (Owner)Commented:
Thank you for the update and I was happy to help.
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
Office Productivity

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.