Excel Locked for Editing

February 5, 2010 at 08:09:52
Specs: Windows Vista
My Excel keeps on showing a window which says, Excel locked for editing ?

See More: Excel Locked for Editing

Report •

February 5, 2010 at 14:33:15

We really need some more information.

Is the message exactly 'Excel locked for editing'
Is this in a dialog box, if so what is the title of the box.

Is there any more information shown or is it only 'Excel locked for editing'

Tell us what you are trying to do when you get this message. Are you opening Excel itself, or are you opening a file.

If its a file is it stored on your own PC/laptop or is it stored on a server.

Is the copy of Excel on your own PC/Laptop or is it loading from a server.

The more information, the more chance of getting a useful answer.


Report •

February 6, 2010 at 05:34:44
Thanks for your input whoever you are.
What I am trying to do is to open an Excel file which is on my desktop as an icon, the file is one of 4 similar files each in there own right, they are the files of the accounts of the Projected Picture Trust here in the UK of which I am the treasurer, they are headed "Mar2004 to Feb2005" "Mar2005 to Feb2006" and so on.
I can open all of them apart from the current and with this I get a dialog box as follows

File in use. ? X
Mar2009 to Feb2010.xls locked for editing by Brian ( Me )
Three buttons. READ ONLY
Click notify to open a read only copy of document and to receive notification wnen Doc is no longer in use.
This started happening about 4 months ago and can be got round by using system restore, this will allow the file to be opened from just once to 3 or 4 times then it reverts to locked etc.
As I need to open and close several times a day normally, and my end of year audit soon due together with the requirement to submit these accounts to the Charities Commission, you can see that I have, what I see as a real problem.
Exel as a program opens ok, and the whole thing is on a PC with Windows Vista. I am 74 years of age and fairly clued up on computing, but this beats me.
Any help you can give me will be much appreciated by me and the PPT

Report •

February 6, 2010 at 05:58:26

There may be other solutions offered, but what comes to mind is that this workbook is corrupt.

I suggest opening Excel, and save a new blank workbook with a name such as Temp.xls.

Change the individual worksheet names to match those in the offending workbook.

Open the offending workbook. Copy each sheet in turn, and paste to the sheets in the Temp workbook.

Save Temp

Close the offending workbook.

Go to the folder with the offending workbook and rename it.
Now rename Temp.xls to the same name as the original offending workbook.

Now see if it works OK.


Report •

Related Solutions

February 6, 2010 at 07:17:29
Try clearing all of your temp folders.

Excel creates a tmp file whenever a file is open. Windows is notorious for not cleaning up after itself. Perhaps the tmp file has not be deleted and when Excel sees the tmp file it thinks the file is open.

Since you own the tmp file, Excel informs you that you have the file open.

Report •

Ask Question