File is locked for editing message

[MSNews]

I have excell 2007 and when I try to open a non shared file I created in my
network share I get a message that the file is locked for editing. I have
ownership of that share and I see no reason why this would come up. Is this
an excel issue that can be fixed?

Thanks

Carl
--

 

[Gord Dibben]

When you open a workbook in Excel a temporary copy is created.

When you close the workbook the temporary file should be deleted.

At times your OS does not do its job and the temp file is left open.

This will give you the "locked for editing" message.

It is usually necessary to re-boot to clear it out.

I don't think it is an Excel issue specifically.


Gord Dibben MS Excel MVP

 

[MSNews]

Would this temp file be on the server or in a temp directory on client? The
user said he saw no temp file. in his user directory.

thanks
Carl

 

[Gord Dibben]

I'm not a network person..........strictly single user.

Which "user" directory was user looking in?

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

Look for ~arxxxxx.XAR files to delete.

File may be on the server??


Gord