file

A

amy

I have an excel file that an employee tried to save and
somehow has an error message on it that it will not save
because locked by another station. I have done everything
from trying to find out who last used it to deleting it
and starting over and nothing works.

PLEASE HELP
amy
 
G

Gord Dibben

Amy

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 the 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