Guest Lasse Posted September 1, 2008 Posted September 1, 2008 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
Guest Pegasus \(MVP\) Posted September 1, 2008 Posted September 1, 2008 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.
Guest Lasse Posted September 8, 2008 Posted September 8, 2008 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. > > >
Guest Lasse Posted September 8, 2008 Posted September 8, 2008 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. > > >
Guest Dusko Savatovic Posted September 8, 2008 Posted September 8, 2008 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. >> >> >>
Guest Lasse Posted September 9, 2008 Posted September 9, 2008 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. > >> > >> > >> > >
Recommended Posts