LOCKED EXCEL WORKBOOK

[GARY HARDY]

I have a workbook that somehow became "locked". I don't know how or why
and also don't know how to unlock it or even what "locked" means. I
checked the "properties" of the workbook and it doesn't show it as "read
only" but it comes up that way. I can't even delete the file. When I
bring it up I get the message Locked for editing by ". Confused.. Gary

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank Kabel]

Hi
you may check:
http://www.contextures.com/xlfaqApp.html#ReadOnly

 

[Gord Dibben]

Gary

One possible cause.......

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

 

[Gary Hardy]

Frank..Gord..
Thanks.. the problem was the temp files. Can I delete all the files &
folders in the TEMP folder without having any problems. Gary

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Gord Dibben]

Gary

Re-boot first just in case you have any pending install or update being done
which requires any of the Temp files for completion.

After re-start, clear Temp folders.

I run a small *.vbs file which deletes all on re-boot, so keep clean.

Gord