1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel shared books won't unlock

Discussion in 'Business Applications' started by huguyguy, Apr 29, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. huguyguy

    huguyguy Thread Starter

    Joined:
    Apr 29, 2010
    Messages:
    2
    Hi,
    We have shared an excel document on a shared drive with 10 different user, from time to time, it shows that the excel document is locked although it isn't, we have to wait hours before being able to open the workbook gain.
    What can be the issue?

    thanks for your help

    Max
     
    huguyguy, Apr 29, 2010
    #1
  2. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    Welcome to the forum.

    Sometimes windows forgets that everyone has let go of the file and then it will keep diferent files in a locked state. Usually if that last person that was previously in the file reboots their pc then it usually will free up the file. Can you let me know what version of Excel you are using and how you went about sharing the file? I want to verify that you did it correctly. ;)
     
    jimr381, Apr 29, 2010
    #2
  3. huguyguy

    huguyguy Thread Starter

    Joined:
    Apr 29, 2010
    Messages:
    2
    thanks for your reply
    Not sure what steps did the Team take to share the book, but if for instance the book is locked under my name and I reboot my pc it doesn't solve the issue
    Excel is 2003 SP3
     
    huguyguy, Apr 30, 2010
    #3
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    One posibility could be the rigths you have on the shared network folder.
    Maybe you are allowed to read, write and create but not to delete.
    In this last case the lock file which is created will not be deleted / removed and therefore it remains locked.
    Contact the system administrator and ask it this could be possible.
    Solution: add delete rights to this particular folder.
     
    Keebellah, May 2, 2010
    #4
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Excel shared books
  1. ybor10000

    Excel file for storing macros closes when trying to view mac

    ybor10000, Mar 25, 2020 at 11:49 AM, in forum: Business Applications
    Replies:
    1
    Views:
    245
    Cookiegal
    Mar 26, 2020 at 9:07 AM
  2. crashdown

    Solved Excel seperate data into a Matrix

    crashdown, Mar 10, 2020, in forum: Business Applications
    Replies:
    1
    Views:
    544
    crashdown
    Mar 11, 2020
  3. ubamous3

    Excel (2010) mouse auto lose focus on current editing cells

    ubamous3, Feb 22, 2020, in forum: Business Applications
    Replies:
    4
    Views:
    920
    DaveA
    Mar 2, 2020
  4. sjtrupp

    excel truncating last digit after period

    sjtrupp, Feb 19, 2020, in forum: Business Applications
    Replies:
    1
    Views:
    840
    cwwozniak
    Feb 19, 2020
  5. saj1011

    How to pull in data from Sheet A to Sheet B in Excel?

    saj1011, Feb 19, 2020, in forum: Business Applications
    Replies:
    2
    Views:
    892
    Professionalgirl
    Mar 1, 2020
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/919972

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice