HolidayBuyer's Guide

Office & Productivity Software forum

General discussion

Excel "Locked for Editing" Condition

by Cyberslick / July 22, 2005 2:49 AM PDT

I have an Excel 2003 workbook that keeps getting the dreaded "Locked for Editing" condition. The only way I know of to clear it is to reboot, which has become a REAL nuisance. I am the only one using this computer and I have no shared resources. I have about 26 workbooks, most of which I reference each day without a problem. I can't determine when the "L for E" condition occurs. It doesn't always occur after use. But for some unknown reason, when I open the workbook, there it is. So I can make changes but I can't save them, except to a workbook with another name. This is not a new workbook ... I've been using it for several years. Any ideas??

Discussion is locked
You are posting a reply to: Excel "Locked for Editing" Condition
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Excel "Locked for Editing" Condition
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
That error occrus
by El Alquimista / July 22, 2005 7:45 AM PDT

when you already have that particular file open in an Excel window. If, for exampke, you have been working with File1.xls and then minimize it, you may forget it is open. Later you want to work on File1.xls again, and try to open it in a new Excell window. You will get the error message because it is already open.

The error also occurs, of course, if one ''user'' has a shared file open and then another tries to open it.

The next time you get this message, check your open and minimized windows for an already open copy. Then you should go to that window to work on it.

BTW, the exact same thing happens with Word files.

Hope this helps

Frank

Collapse -
The Excel "Locked for Editing" Problem
by Cyberslick / July 23, 2005 4:03 AM PDT
In reply to: That error occrus

[quote]when you already have that particular file open in an Excel window. If, for exampke, you have been working with File1.xls and then minimize it, you may forget it is open. Later you want to work on File1.xls again, and try to open it in a new Excell window. You will get the error message because it is already open.[/quote]

Thanx for the advice. I am aware of the ''minimize'' threat, and that is not the case. Anyway, if that happened, Excel tells me that I already have the file open, and asks if I want to open it again. This situation occurs when I have opened just that one workbook. It's not a new problem to me. I had the same problem with other workbooks when I was using Excel 2000.
More recently the problem got so bad that I changed all my automatic links in most of my workbooks to ''manual'' links, and that has helped enormously. But for some reason this one workbook started doing it again. I'll probably have to rebuild the workbook to correct it.
Thanx again.

Popular Forums
icon
Computer Newbies 10,686 discussions
icon
Computer Help 54,365 discussions
icon
Laptops 21,181 discussions
icon
Networking & Wireless 16,313 discussions
icon
Phones 17,137 discussions
icon
Security 31,287 discussions
icon
TVs & Home Theaters 22,101 discussions
icon
Windows 7 8,164 discussions
icon
Windows 10 2,657 discussions

HOLIDAY GIFT GUIDE 2017

Cameras that make great holiday gifts

Let them start the new year with a step up in photo and video quality from a phone.