Excel workbook

I

it.it.just.me

?I have a password protected workbook. No one seems to be using it, but it
shows as being locked for editing. How can I recover and reopen this workbook
 
F

Frank Kabel

Hi
search Google for 'Excel password remover'

--
Regards
Frank Kabel
Frankfurt, Germany

it.it.just.me said:
?I have a password protected workbook. No one seems to be using it, but it
shows as being locked for editing. How can I recover and reopen this
workbook
 
G

Gord Dibben

For the "locked for editing" problem...........

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 locked for editing.

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
 
Top