Excel: Saved & closed workbook. Now locked for editing (?).

[Rhett]

Thanks for the help with this. I saved my workbook (clicked icon) now when I
try to open it the #$@!! thing says it's locked while "!" (me) is editing it
and do I want to be notified when it's available.

 

[Roger Govier]

Hi
Close File
Open My Computer>navigate to where file is Stored>right click on File
Name>Properties>uncheck Read Only
In Excel re-open file

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Rhett]

Thanks for the information but I had tried this.

 

[Rhett]

Thanks for the answer!

 

[Gord Dibben]

Good to hear.

Thanks for the feedback.