file locked after Excel crash
 

Excel crashed while copying row. Get 'file open by another user' msg when
trying to re-open. Copied file in order to keep working. How do I get rid
of old file?
--
JB

file locked after Excel crash
 

What happened is that Excel didn't totally go away after the crash, but
remained in memory with a link to that file. You can go to the task manager
(Ctrl+Shift+Esc) and on the processes tab, look for excel.exe and any of
these processes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JB Dayrelton" wrote in message
...
Excel crashed while copying row. Get 'file open by another user' msg when
trying to re-open. Copied file in order to keep working. How do I get
rid
of old file?
--
JB

file locked after Excel crash
 

You most likely have a *.tmp file which Excel creates when working on a
workbook.

This is to be deleted when the workbook or Excel closes normally but your crash
left it hanging.

Most a re-boot is necessary to get rid of the *.tmp file.


Gord Dibben MS Excel MVP

On Tue, 1 Apr 2008 06:04:01 -0700, JB Dayrelton
wrote:

Excel crashed while copying row. Get 'file open by another user' msg when
trying to re-open. Copied file in order to keep working. How do I get rid
of old file?

file locked after Excel crash
 

On Apr 1, 9:04*pm, JB Dayrelton
wrote:
Excel crashed while copying row. *Get 'file open by another user' msg when
trying to re-open. *Copied file in order to keep working. *How do I get rid
of old file?
--
JB

Hi,

I think maybe your excel file is damaged, but you can try a utility
called Advanced Excel Repair to repair your Excel xls file. It works
rather well for my corrupt Excel xls files. Its web address is
http://www.datanumen.com/aer/

Hope this helps.

Alan

file locked after Excel crash
 

JB

Re-boot the computer.

Excel stores a termporary file while you are working on a workbook.

Normally, the *.tmp file is deleted when Excel and the workbook are closed but
due to the crash, the *.tmp gets stuck.


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 05:39:38 -0700 (PDT), Alan124 wrote:

Excel crashed while copying row. *Get 'file open by another user' msg when
trying to re-open. *Copied file in order to keep working. *How do I get rid
of old file?
--
JB