Server 2003 R2 problem with locked files

[Lasse]

Hi

I don't know if this is the correct place to post my message but here goes

The last couple of weeks we have started encountering a problem with some of
our clients. Sometimes when they want to open a Excel document they get an
error from Excel telling that the document is already opened by the same
user. The user have normally used the exact same document earlier the same
day so it should be fine.
The only solution I have found is to make a copy of the file and then
restart the server which isn't very usefull.
If I check which files are open on the server the locked file is not on the
list.

Any idea?

/Lasse

 

[Pegasus \(MVP\)]

Re: Server 2003 R2 problem with locked files


"Lasse" <Lasse@discussions.microsoft.com> wrote in message
news:0D950E25-F9ED-488F-BEB8-0ECA398B30EC@microsoft.com...
> Hi
>
> I don't know if this is the correct place to post my message but here goes
>
>
> The last couple of weeks we have started encountering a problem with some
> of
> our clients. Sometimes when they want to open a Excel document they get an
> error from Excel telling that the document is already opened by the same
> user. The user have normally used the exact same document earlier the same
> day so it should be fine.
> The only solution I have found is to make a copy of the file and then
> restart the server which isn't very usefull.
> If I check which files are open on the server the locked file is not on
> the
> list.
>
> Any idea?
>
> /Lasse

This is often caused by a malformed "open" instruction on the user's PC. You
will need to remove the "%1" item. Have a look here for further details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;200915.

 

[Lasse]

Re: Server 2003 R2 problem with locked files

Hi

I have tried the solution but I don't know if it works yet. The strange
thing is that we have 4 locations and it's only a problem at one of the
locations. It's the same setup at all the locations, Server 2003 R2 with
Windows XP SP2 clients running Office 2003. The actual problem only occur in
Excel 2003.

"Pegasus (MVP)" wrote:

>
> "Lasse" <Lasse@discussions.microsoft.com> wrote in message
> news:0D950E25-F9ED-488F-BEB8-0ECA398B30EC@microsoft.com...
> > Hi
> >
> > I don't know if this is the correct place to post my message but here goes
> >
> >
> > The last couple of weeks we have started encountering a problem with some
> > of
> > our clients. Sometimes when they want to open a Excel document they get an
> > error from Excel telling that the document is already opened by the same
> > user. The user have normally used the exact same document earlier the same
> > day so it should be fine.
> > The only solution I have found is to make a copy of the file and then
> > restart the server which isn't very usefull.
> > If I check which files are open on the server the locked file is not on
> > the
> > list.
> >
> > Any idea?
> >
> > /Lasse
>
> This is often caused by a malformed "open" instruction on the user's PC. You
> will need to remove the "%1" item. Have a look here for further details:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;200915.
>
>
>

 

[Lasse]

Re: Server 2003 R2 problem with locked files

I forgot a couple of things.

The solution I used from the link was "\Excel /regserver". I have just tried
to remove the "%1" from Excel.Sheet.8>Shell>Open>Command but it only results
in me not being able to doubleclick on a Excel document and open it, I can
only open a document by opening Excel and selecting Open.

"Pegasus (MVP)" wrote:

>
> "Lasse" <Lasse@discussions.microsoft.com> wrote in message
> news:0D950E25-F9ED-488F-BEB8-0ECA398B30EC@microsoft.com...
> > Hi
> >
> > I don't know if this is the correct place to post my message but here goes
> >
> >
> > The last couple of weeks we have started encountering a problem with some
> > of
> > our clients. Sometimes when they want to open a Excel document they get an
> > error from Excel telling that the document is already opened by the same
> > user. The user have normally used the exact same document earlier the same
> > day so it should be fine.
> > The only solution I have found is to make a copy of the file and then
> > restart the server which isn't very usefull.
> > If I check which files are open on the server the locked file is not on
> > the
> > list.
> >
> > Any idea?
> >
> > /Lasse
>
> This is often caused by a malformed "open" instruction on the user's PC. You
> will need to remove the "%1" item. Have a look here for further details:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;200915.
>
>
>

 

[Dusko Savatovic]

Re: Server 2003 R2 problem with locked files

Sorry, but I jumped late into this thread so I don't know which replies you
received.
Is it possible that someone opened this file using RDP and then simply
disconnected from the session without logging of and/or closing the file?
You may check with Terminal Services Manager on the server.


"Lasse" <Lasse@discussions.microsoft.com> wrote in message
news:36DA72F5-F00E-4667-A7D5-80AB0193C97E@microsoft.com...
>I forgot a couple of things.
>
> The solution I used from the link was "\Excel /regserver". I have just
> tried
> to remove the "%1" from Excel.Sheet.8>Shell>Open>Command but it only
> results
> in me not being able to doubleclick on a Excel document and open it, I can
> only open a document by opening Excel and selecting Open.
>
> "Pegasus (MVP)" wrote:
>
>>
>> "Lasse" <Lasse@discussions.microsoft.com> wrote in message
>> news:0D950E25-F9ED-488F-BEB8-0ECA398B30EC@microsoft.com...
>> > Hi
>> >
>> > I don't know if this is the correct place to post my message but here
>> > goes
>> >
>> >
>> > The last couple of weeks we have started encountering a problem with
>> > some
>> > of
>> > our clients. Sometimes when they want to open a Excel document they get
>> > an
>> > error from Excel telling that the document is already opened by the
>> > same
>> > user. The user have normally used the exact same document earlier the
>> > same
>> > day so it should be fine.
>> > The only solution I have found is to make a copy of the file and then
>> > restart the server which isn't very usefull.
>> > If I check which files are open on the server the locked file is not on
>> > the
>> > list.
>> >
>> > Any idea?
>> >
>> > /Lasse
>>
>> This is often caused by a malformed "open" instruction on the user's PC.
>> You
>> will need to remove the "%1" item. Have a look here for further details:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;200915.
>>
>>
>>

 

[Lasse]

Re: Server 2003 R2 problem with locked files

Hi

We do indeed use a Terminal server but in this case the users haven't had
the file opened through RDP.

"Dusko Savatovic" wrote:

> Sorry, but I jumped late into this thread so I don't know which replies you
> received.
> Is it possible that someone opened this file using RDP and then simply
> disconnected from the session without logging of and/or closing the file?
> You may check with Terminal Services Manager on the server.
>
>
> "Lasse" <Lasse@discussions.microsoft.com> wrote in message
> news:36DA72F5-F00E-4667-A7D5-80AB0193C97E@microsoft.com...
> >I forgot a couple of things.
> >
> > The solution I used from the link was "\Excel /regserver". I have just
> > tried
> > to remove the "%1" from Excel.Sheet.8>Shell>Open>Command but it only
> > results
> > in me not being able to doubleclick on a Excel document and open it, I can
> > only open a document by opening Excel and selecting Open.
> >
> > "Pegasus (MVP)" wrote:
> >
> >>
> >> "Lasse" <Lasse@discussions.microsoft.com> wrote in message
> >> news:0D950E25-F9ED-488F-BEB8-0ECA398B30EC@microsoft.com...
> >> > Hi
> >> >
> >> > I don't know if this is the correct place to post my message but here
> >> > goes
> >> >
> >> >
> >> > The last couple of weeks we have started encountering a problem with
> >> > some
> >> > of
> >> > our clients. Sometimes when they want to open a Excel document they get
> >> > an
> >> > error from Excel telling that the document is already opened by the
> >> > same
> >> > user. The user have normally used the exact same document earlier the
> >> > same
> >> > day so it should be fine.
> >> > The only solution I have found is to make a copy of the file and then
> >> > restart the server which isn't very usefull.
> >> > If I check which files are open on the server the locked file is not on
> >> > the
> >> > list.
> >> >
> >> > Any idea?
> >> >
> >> > /Lasse
> >>
> >> This is often caused by a malformed "open" instruction on the user's PC.
> >> You
> >> will need to remove the "%1" item. Have a look here for further details:
> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;200915.
> >>
> >>
> >>
>
>