Deleting Excel file

[John S]

I am trying to delete an Excel file, but receive the
following error:
"Cannot delete abc.xls: there has been a sharing violation.
The source or destination file may be in use."

If I attempt to open the file I receive the following
error:
'abc.xls' is being modified by John Doe
Open as read only or choose Notify to be alerted when it
is availble.

The thing is...John Doe is not and has never opened this
file.
When I go into System Tools|Shared Folders|Open Files
the file doesn't show as being open.
Any suggestions?

Thanks - John

 

[Gord Dibben]

John

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, or just "because"), so Excel
thinks it is still open.

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 you are on a Net, the temp folder could be just about anywhere and the
server may have to be re-booted, though not likely.

Notes on deleting Windows\Temp files............

Re-boot to make sure there are no Temp files being used by Windows(program
installs, updates etc.) It is easy to forget that when Windows stated "Your
Computer needs to re-boot to complete this update. Re-boot Now?" and you
clicked "No, I'll do it later". The files are stored in Windows\Temp folder.
If you delete them before a re-boot, you can hoop whatever was going on.

After the re-boot, select all files in Windows\Temp folder and delete....

Gord Dibben Excel MVP

 

[Guest]

Gord,

I appreciate the information.

- J