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
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??