Excel 2010 doesn't check in document when close the excel window RRS feed

  • Question

  • the Excel file is kept checked out even after user save and close the Excel by clicking the "X" on the window if user didn't explicitly checked it in. WSS3 will keep it checked out then the sharepoint administrator has to check it in. this doesn't happen in excel 2007 or earlier version.

    • Edited by Mike Walsh FIN Tuesday, March 22, 2011 6:32 PM Do not shout in Titles
    • Edited by George Zhou Wednesday, March 23, 2011 3:53 PM did my previous subject title shout? not sure, sorry, any way changed it as it is now.
    Tuesday, March 22, 2011 5:18 PM

All replies

  • Hi George,

    First of all please check below option in doc lib settings 

    Doc Lib Settings > Versioning Settings > Require Check Out

    Check it is "YES" or "NO"

    If its yes then at the time of editing Excel document is asking to check out the doc first and when you close the document is it asking to check it in back.

    If its No enable "YES" and follow above steps.

    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    Wednesday, March 23, 2011 8:20 AM
  • thanks Pratik. it is YES. but EXCEL 2010 seems has new feature, even you checked out from sharepoint(when click and choose check out and edit), it still require to check out inside excel 2010, but not the case in previous edition. regarding check in, if user made changes and saved the document, then click "x" to close Excel, it won't ask to check in but close the Excel, which leaves the document "checked out" on sharepoint, no body can check it out unless sharepoint administrator to check in.
    Wednesday, March 23, 2011 3:50 PM
  • George,


    Where you ever able to resolve this issue?  I am having the same problem and it is very troublesome.


    Thank you,


    Thursday, October 6, 2011 11:13 PM