Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Workbook is Locked (Excel2k SR1a)

    I have a workbook that is in use frequently during the day. This workbook resides on a network but with restricted access so that only a few people may access it. Yesterday it was used in the morning and then in the afternoon when it was attempted to be used (by an authorised user) it came up with the message that the workbook was in use by "Steve" and then asked if the user wanted to open a read only or notify edition of the workbook (which is read only until released).
    My question is this... as the same user had already accessed the workbook earlier that day and it was on the same machine, and no crash occurred whilst using the workbook then, why would the damn thing be locked now? and more importantly how do I unlock it?
    The PC that is using this workbook has office 2K SR1a loaded on it and is registered to user "Steve". The user that accesses this file is logged onto the pc under a different name. I have tried logging onto the same PC as "Steve" and accessing this file but I am still getting the same response.
    Any help would be really appreciated!
    Thanks in advance,
    Brian.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    I have seen this happen (never found out why - it could be a network error during unlock). The usual solution was to have the user that had it locked reboot.
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Well this problem seems to have resolved itself over the weekend.
    The only thing that happened was that the server died (memory fault) and had to be rebooted.
    Now all locked excel files are ok. go figure! Good ol MS strikes again!
    Brian.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Rebooting the server would have been my second suggestion...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Mine too. And the fact that it died indicates that it needed it.
    Legare Coleman

  6. #6
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Have your system administrator go to Shared Folders, Open Files on the server, find the File/User then select close the Open file. Often the browser will take a while to update, or the update does not take place.
    I have this issue from time to time and this is how I re-set the file so another user can access.
    HTH <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>
    Paul Coyle
    Approach love and cooking with reckless abandon

  7. #7
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Replaced the memory in the server and all is OK on that front... but the file locking problem seems to randomly appear! I have copied the file to the local HDD and have run the file from there and this seemed to unlock the file on the server.... Can't figure that one out at all! maybe it is because the files have the same name?
    Any more suggestions?
    Regards
    Brian.

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Shot in the dark: Anti virus software settings on the sevrer?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Run a full ChkDsk on the server - chances are there is a problem with the security description.
    (Right_click the drive from 'My Computer' > Properties > Tools > Error Checking. You will probably need to do it during boot-time.)

  10. #10
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Not absoluteley sure on the exact settings but we are running Trend antivirus software on the server.
    If the antivirus software was looking at the file as being suspicious would it not tell me straight away that this file ... is sus?
    Brian.

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook is Locked (Excel2k SR1a)

    Not necesarily, if the AV software is reviewing the file while in the same time Excel tries to open it, well, that might cause "in use" msgs from Excel. But I don't think this is very likely. Problems with AV software is mostly when *saving* from Excel.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •