How to stop: Microsoft XLS is locked for editing in 2003 Excel

[shorns]

Help on Office / Excel 2003 to stop the "Microsoft XLS is Locked for Editing"
and then keeps showing "Read" or "Notify" from coming up almost every time
Excel 2003 is opened.
Thanks / shorns

 

[Gord Dibben]

Are you opening files from external media like a CD?

Or more likely this problem

When you are working on an Excel workbook(file) Excel will create a
temporary copy of that file.

Generally when you close the file the temporary is deleted.

Sometimes it is not.

Then you will get the "this file is locked for editing by username".

Most times a re-boot will clear it up but sometimes you must clear your Temp
folder and/or the folder

C:\Documents and Settings\username\Application Data\Microsoft\Excel

If on a network, the server may have to rebooted.


Gord Dibben MS Excel MVP