file lock problem

[Roger Smith]

Hi Experts

I have recently inherited a problem with file locking. the problem is
inconsistent, but most of the time when I close a file and try to reopen it
or when I exit excel and then try to reopen the file I get the "File Locked
by Another User" error. But there are no other users. Its not a timing issue
as sometimes the close and the open are days apart. I have searched in vain
for the lock but apparently microsoft has moved it or renamed it. Can
someone please help? Thanks

 

[Gord Dibben]

When you are working on an Excel workbook(file) Excel will create a temporary
copy of that file.

Generally when you close the file the temporary is deleted.

Sometimes it is not.

Then you will get the "this file is locked for editing by username".

Most times a re-boot will clear it up but sometimes you must clear your Temp
folder and/or the folder

C:\Documents and Settings\username\Application Data\Microsoft\Excel


Gord Dibben MS Excel MVP

 

[Roger Smith]

Thanks Gord

This is starting to happen a lot. Am I doing something wrong? It never used
to do this.

What temp folder is this copy stored in?

Cheers,

Roger

 

[Gord Dibben]

Mine show up in

C:\Documents and Settings\Gord\Local Settings\Temp

Where Gord would be your username.

Files with names like ~DFAD7C.tmp


Gord