file lock with excel when file, close workbook instead of exiting Excel completly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jamie - 22 Mar 2007 16:28 GMT

Ok we have some excel files that get locked. Consist on a Win2k3 share.

Basically a user will open them up in Excel and then use File, Close but
keep excel 2003 open. So the file is closed!

Now another user tries to open the file but gets file is open by user open
as read only.

The first user must completly exit excel and then the file becomes
available.

I have done searches and can't find anything this specific. Please anyhelp
would be great.

Jamie

Reply to this Message

Özcan ELMALI - 23 Mar 2007 12:39 GMT

Hi,
May be cache problem, i don't now. But if you want , more than one user at
the same time;

Open Excel File, Tools -- Share Workbook -- check the "Allow changes by
more...." click OK; Save and Close Workbook.

Özcan ELMALI

> Ok we have some excel files that get locked. Consist on a Win2k3 share.
>
[quoted text clipped - 11 lines]
>
> Jamie

Reply to this Message