How do I unlock an Excel spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get the message "Locked for editing by (my name)" when I try to open an
excel file. It gives the options of "read only" or "notify" and "cancel".
How do I get this "lock" off. I don't know how it was put on!!
 
Nona

Try this fix.

Excel stores in Windows\Temp(win98) folder a copy(s) of any file that is open.

Sometimes this *.tmp file is not deleted from the Temp folder when you close
out Excel(maybe a crash of Excel?) or the file, so Excel thinks it is still
open and in use.

You can try a re-boot and see if that clears it up. If not, after a re-boot,
clear out your Windows\Temp folder.

If using WinXP your Temp folder would be under user.......

Documents and Settings\User\Local Settings\Temp

If on a network, re-booting the server may be the only solution.


Gord Dibben Excel MVP

I get the message "Locked for editing by (my name)" when I try to open an
excel file. It gives the options of "read only" or "notify" and "cancel".
How do I get this "lock" off. I don't know how it was put on!!
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top