Solved

Excel Locked file

Posted on 2015-01-28
4
154 Views
Last Modified: 2015-01-30
I have a user in Excel 2010 that asked the question: We are trying to pull up an excel schedule but it says it's locked for editing by me.. I haven't locked it and we are getting read only since it says I'm in the worksheet.
How do we get this fixed quickly so Jeff can get into the worksheet and update his amounts. Is there a way to kill her session on this Locked file?
0
Comment
Question by:millerdog
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
helpfinder earned 350 total points
ID: 40574987
try to check if still some excel.exe process in not running in Task manager
also check in C:\Users\<username>\AppData\Local\Temp for that file and if it appears here delete it
1
 

Author Comment

by:millerdog
ID: 40575015
Thanks. I will try this and get back to you.
0
 
LVL 28

Assisted Solution

by:omgang
omgang earned 150 total points
ID: 40575899
If the Excel file is on a file server you should be able to kill the orphaned session from the server console.
OM Gang
0
 

Author Closing Comment

by:millerdog
ID: 40579840
Thanks that did work. I ended up killing the process and it worked fine.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now