Excel locks for no reason

[Gary Burton]

I am using WinXP Home and Office Professional 2002, as I have been since 2002. Recently, Excel started doing something wierd. When I open my favorite spreadsheet (the one I use for all my financial stuff), I frequently get a dialog that says that the file is locked for editing and I can only open it as read-only. It seems to think that another instance of the spreadsheet is in use when it is not.

So far when I reboot the machine, the problem has gone away. I have not yet seen it with any other spreadsheets. This spreadsheet has a lot of VBA code associated with it, but so do my other spreadsheets. If there were a problem with the VBA, it should occur each time I open the program.

Has anyone else seen this? Is there a solution?

 

[Lady Layla]

This is a common occurance. When this happens, you need to close Excel and
clear out the files in any and all of your temp directories (c:\documents &
settings\username\localsettings\temp and c:\windows\temp). Other solution is as
you stated -- reboot



I am using WinXP Home and Office Professional 2002, as I have been since
2002. Recently, Excel started doing something wierd. When I open my favorite
spreadsheet (the one I use for all my financial stuff), I frequently get a
dialog that says that the file is locked for editing and I can only open it as
read-only. It seems to think that another instance of the spreadsheet is in use
when it is not.

So far when I reboot the machine, the problem has gone away. I have not yet
seen it with any other spreadsheets. This spreadsheet has a lot of VBA code
associated with it, but so do my other spreadsheets. If there were a problem
with the VBA, it should occur each time I open the program.

Has anyone else seen this? Is there a solution?

 

[Gary Burton]

Thank you, Lady!!!