Excel file locked for editing?

mysticsniper

mysticsniper

mysticsniper

Soldato
Joined
1 May 2003
Posts
11,198
I was working on an excel spreadsheet that is stored on a Shared Drive,

I went for a break and when I returned to the file and carried on working away. When I came to save the file, an error message appeared "excel file locked for editing".

How can some one kick me out of the file I was working on and then block me from making changes?
 
edscdk said:
is someone actually editing it or did ex crash and is still running on your PC holding hte file open???
Click to expand...

There wasn't any issues with excel, but when I came to save me work, it said it was open with some one else and I was unable to make any changes. I saved the file to my desktop and closed it down.

I went to the share to open the file, it told me it was locked by "user" and it said I could only open it in read only, or I had to notify the other user.

But If I was the first one to open the file this morning, it should be locked to my user id??
 
No, my laptop is setup so it doesn't goto sleep, or turn off any hard drives.

Could the person in question save his own copy and delete the one on the share then replace the file and open it up in his user id?
 
It's possible you lost your connection to the share somehow. If that happened, the tmp file on the share won't close properly, and Excel will then think the file is already in use when you try to reconnect.

You'll have to contact your SA to look at the share and find out if there is a tmp file and if it is in use by you or someone else. They can then close the file out using adminstrative tools.
 
You must log in or register to reply here.
Back
Top Bottom