Forum Discussion

tony thomas's avatar
tony thomas
Copper Contributor
Aug 30, 2018

Excel locked sheets

A few days ago, ALL of my Excel sheets are locked and I cannot make edits to any of my sheets. I have followed the unprotect sheets as instructed..i.e.. Review tab > unprotect sheet as well as tool tab> protection> allow users to make changes....nothing works...Any ideas?

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor

    Hi tony thomas

     

    You've probably checked this but I'll ask to eliminate some of the potential causes, are you sharing the documents with other users? Other people may have the file/s open and locked (happens in my workplace sometimes where people forget to close the file).

     

    If not, have the folder permissions changed? E.g. are you using SharePoint or accessing someone's OneDrive?

     

    If none of the above please let us know a bit more details as to where the files are stored and what you have been doing recently so we can find out any possible causes.

     

    Cheers

    Damien

Resources