Forum Discussion
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_RosarioSilver 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