locked for editing

[Barb]

I have a workbook that is on my local drive... when i open
it, it says that I have it locked for editing????? i
closed excel tried again..same thing i even verified
excel? Any ideas? I have office 2k on win 2k.

Thanks
Barb

 

[Gord Dibben]

Barb

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

 

[Jonathan Rynd]

I have a workbook that is on my local drive... when i open
it, it says that I have it locked for editing?????

If this happens to all workbooks, it is possible that your Excel is
infected with a macro virus. But that doesn't seem to be the case for you.