Excel file does not deleted

G

Guest

Dear All
Some times what happens that computer get shut down while an excel/ms word
file kept opened. after I restart the computer, file opens as read only and
if I want to delete the file, it does not get deleted , or cant be moved to
another folder or even it cant be renamed. How to tackle this problem
 
M

MartinW

Hi Abhishek,

Here is Gord Dibben's answer to a similar question in another group
it may be what you are looking for.

<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 in use.

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 other than
copying the data to a new workbook.

HTH
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top