Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2087
  • Last Modified:

Excel Lock File

Does anyone know how Excel locks a file?  For example, if I have a document open in Excel, and then I open it in another instance I cannot make changes because the first instance of Excel has "locked" it.

The reason I ask is that I have a problem with Excel crashing.  Because it does not unlock the file, in order to reopen and edit my file I have to reboot my machine.  If I could just delete the lock file then I think I could just start back up at my last save?

Thanks,

Uziel
0
Uziel
Asked:
Uziel
  • 5
  • 5
  • 4
1 Solution
 
bruintjeCommented:
Hi Uziel,

difficult do you know why it's crashing? a pattern?

-you can try to clean up the windows/temp dir after a crash

:O)Bruintje

0
 
UzielAuthor Commented:
No, it crashes at irregular times.  The latest series is from copying by dragging a sum cell.  That should not happen...

I cleaned the temp file, and hopefully that will work.

Do you understand what I am asking for?  If I knew what file tracked what Excel files are locked, like an Access lock file, then I could just delete it and re-open my file.
0
 
bruintjeCommented:
yeah i got that, only excel makes it's temp files in the temp directory and by cleaning that one up, i looked once in a while for users to see what those files where named because they had crashes too. but it's a bit difficult you've to look for files named *.xls in the temp dirctory and i'm not even sure they're called .xls or something else
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Richie_SimonettiCommented:
Which version of Excel are you using?, which SP?
0
 
UzielAuthor Commented:
Excel 2000 9.0.4402 SR-1

Does that help?
0
 
Richie_SimonettiCommented:
No.
did you try reinstalling SP?
0
 
UzielAuthor Commented:
I reinstalled everything.  I cleaned the tmp files.  Nothing really helps...
0
 
bruintjeCommented:
i'm rereading the Q here

For example, if I have a document open in Excel, and then
I open it in another instance I cannot make changes because the first instance of Excel has "locked" it

do you want to open it two times at the same time?

:O)Bruintje
0
 
UzielAuthor Commented:
No.  I want to know if there is a way to "Unlock" a file after I crash.  When I open the file, it becomes locked.  If I crash it stays locked and the only way to unlock it that I know of is to reboot.

0
 
Richie_SimonettiCommented:
It appears like Excel creates a tmp file in c:\%windir%\temp with name: ~DF*.tmp that cannot be read it or edited.
0
 
bruintjeCommented:
you can also try to Close Excel using Ctrl+Alt+Delete

it seems that when crashing, Excel remains semi-open and it is this semi-open file that prevents you opening normally
0
 
UzielAuthor Commented:
Bingo!  That was it.  As soon as I closed the "shadow" excel with the task manager the file became unlocked.

Thanks!
0
 
bruintjeCommented:
wow glad that did it, funny how we sometimes overlook the most obvious ones to try
0
 
Richie_SimonettiCommented:
Gee, i was thinking that you need a code solution not a "hard-coded" one! :))
Bruintje, i agree with your last comment also.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 5
  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now