?
Solved

File in use error

Posted on 2012-03-19
5
Medium Priority
?
176 Views
Last Modified: 2013-07-22
In Excel 2007 running on Windows 7 Professional, we constantly get file in use error eventhough the file is not being used by other user. Please let us know how to fix this issue.
0
Comment
Question by:JCCANYHELPDESK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 21

Expert Comment

by:CompProbSolv
ID: 37738851
It would be useful to know what generates the error.  Is it starting Excel?  Opening a specific file?  Saving the file back?
Is the file located on the local computer on a different computer?
Lastly, there are a number of programs out there that will show you what has locked a file (if that really is the source of the error message).  I have used "unlocker", but a search on that term will show you a variety of tools to accomplish this.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 37738910
Do you explicitly Close the file when you're done with it?
0
 
LVL 2

Accepted Solution

by:
BigRMV earned 2000 total points
ID: 37738919
Is this a file on a shared, networked machine?  If so, you'll need to log onto the network storage host machine's console and then look to see if the file is open on that system.  To do this:

-- Open a Windows Explorer window
-- Right-mouse click on the host's MY COMPUTER
-- Select MANAGE from the context menu
-- Under SYSTEM TOOLS, expand the SHARED FOLDERS item
-- Click on OPEN FILES and search for the drive\path\filename that shows up as open.  If it's there, you'll see which user has it open and whether or not it's locked.
-- Contact the user who has it open.  If that user isn't using it, right-mouse click on the file and select CLOSE OPEN FILE from the context menu.

If this file is not on the network, this could be a permissions problem.  To find out if you have rights to that file:

-- Navigate to the directory housing the file.
-- Right-mouse click on the file and select PROPERTIES from the context menu.
-- Click on the SECURITY tab at the top.
-- Look for your username in the list.  If it's there, click it and make sure that you have at least MODIFY rights to that file.
-- If not, give yourself rights to that file if allowed.  

If you do have MODIFY rights but still can't get into that file or if you can't change the rights, try to take ownership of it by following the first 3 steps above and:

-- Click the ADVANCED button.
-- Click the OWNER button.
-- If you are already the owner, stop.  The problem is elsewhere.  Otherwise, click the EDIT button.  
-- If your user isn't in the CHANGE OWNER TO list, click the OTHER USERS OR GROUP button.
-- Select your username from the list and click OK.
-- Select your username from the CHANGE OWNER TO list and click the OK button.
-- "OK" your way out and try to open the file.

If none of this has worked, you may have a corrupted or locked file.  The quickest way to unlock all files is a system reboot.  You can also use a program like UNLOCKER ( http://majorgeeks.com/Unlocker_d4660.html ) to clear the lock.

If the file is corrupted, you can try to repair the file(s) by running a disk checking program.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

770 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