Excel Files Locked for Editing

  • Thread starter Thread starter PeterF
  • Start date Start date
P

PeterF

I hace a network install of Office XP Pro and when I
start Excell i get file is locked for editing. referring
to a temp file in the xlstart folder on the network. I
cannot delete the file because it is opened but I can
rename the xlstart folder and create a new xlstart
folder, to correct the problem for a short period of
time. Then the problem comes back. any suggestions on how
to correct this file lock situation?
Thank you, Peter
 
Peter

I have no idea why you have a Temp file in your XLSTART folder. That is not
the default location for Temp files. You may be opening files from there so
that might cause it.

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.

You might try re-registering Excel.

Start>Run "excel.exe /regserver"(no quotes)

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top