Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 72,255 times.
Learn more...
This How.com.vn will teach you how to change an Excel sheet from a read-only status using a computer. If you're the owner of the file, this is a fairly simple process; however, if you're not the original creator of the file, there are limited solutions to this issue.
Steps
Download Article
Open your project in Excel. If you're in Excel, you can go to File > Open or you can right-click the file in your file browser.- This method works for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019-2007, and Excel 2019-2011 for Mac.
- If you open an Excel file that was sent to you and it opens but gives you a pop-up warning that read-only is recommended, you can click either Yes if you don't want to make edits or No if you want to make edits. To prevent that pop-up from appearing in the future, go to File > Save As > Browse > Tools > General Options and deselect "Read-only recommended."
- Some files may not let you edit unless you enter a password. You'll be prompted for this password when you open the file; if you cannot type the right key, you will not be able to edit the file.
Click the File tab. You'll find this either above your document editing space or running along the top of your screen.- If the file was sent to you as "final", all you need to do is click the Edit Anyway button that's at the top of your screen in the yellow/orange banner.[1]
Advertisement
Click Get Info. You'll see this in the menu that drops-down or slides out.
Click the box to uncheck it next to "Locked." This will change your document from prompting to open in a read-only status.[2]
Expert Q&A
Video
Tips
References
About This Article
1. Open your project in Excel.
2. Click the File tab.
3. Click Get Info.
4. Click the box to uncheck it next to "Locked."
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
