If you feel the current password for your Excel workbook isn’t secure enough, or if you think the password is unnecessary, you can change or completely remove it. However, the steps are a bit different between Windows and Mac. Show
Change or Remove an Excel Workbook Password on WindowsTo change or remove the password of an Excel workbook, you’re going to need to know the current password in order to open the document to begin with. Go ahead and open the workbook and enter the password. Once you’ve opened the workbook, click the “File” tab. Next, click “Info” in the left-hand pane. On the Info screen, click “Protect Workbook” to show a drop-down menu. Now click the “Encrypt with Password” option near the top of the menu.
The Best Tech Newsletter Anywhere Join 425,000 subscribers and get a daily digest of features, articles, news, and trivia. By submitting your email, you agree to the Terms of Use and Privacy Policy. The Encrypt Document dialog box will appear. To change the password, type the new password in the text box and then click “OK.” Or, to remove the password, delete the password in the textbox, leave the textbox blank, and then click “OK.” If you removed the password, then all you need to do now is save your workbook. If you changed the password, you’ll be asked to confirm the new password. In that case, retype the password in the text box and then click “OK” to confirm. Be sure to save your workbook after changing or deleting the password. If you’ve unlocked your workbook but still want certain parts to be difficult to change, don’t forget that you can hide tabs in Excel. RELATED: How to Hide Worksheets/Tabs and Entire Workbooks in Excel Change or Remove an Excel Workbook Password on MacYou can change or remove a password from an Excel workbook on Mac, as well. To do so, you’ll need the current password of the workbook. Open the workbook and then click “File” in the desktop’s menu bar. Next, click “Passwords” near the bottom of the drop-down menu. The File Passwords dialog box will appear. To remove the passwords, delete the passwords from each text box, leave each box blank, and then click “OK.” To change the passwords, enter the new password in each text box and then click “OK.” If you removed the passwords, all that’s left to do is save the workbook. If you changed the password, you’ll be asked to confirm the new passwords. Enter the new password in the text box for each option (a separate dialog box will appear for each option) and then click “OK.” Be sure to save after removing or changing the password. If you removed the password, anyone can access the workbook. If you changed the password, you’ll need to give the new password to every recipient of the workbook. Worried about a certain part being edited? You can even lock specific cells while allowing other parts of the workbook to be modified. RELATED: How to Lock Cells in Microsoft Excel to Prevent Editing This post we show how to remove an Excel spreadsheet password in 6 easy to follow steps. It is an update to an earlier article where we discussed how you may be able to unprotect an Excel spreadsheet if you have forgotten the password used to protect it. Click here to read that article. Unfortunately, there is no way that we can view or recover what your lost password is. However, what can be done is remove the password protection from your worksheets, so you once again have full unrestricted access to your data and information.  Methods to Unprotect an Excel spreadsheetExcelSuperSite Ultimate GuideHow to Unprotect an Excel Spreadsheet (when I have forgotten the password)Here at ExcelSuperSite, we come across many situations where our clients have locked their spreadsheets to prevent access or accidental changes being made, but then, forget or lose access (staff leave and don’t share passwords etc) to the passwords used. So often in fact that we created the following Ultimate Guide. How to Unprotect an Excel Spreadsheet (when I have forgotten the password) This guide presents simple to understand and follow, step-by-step instructions to lead you through all the steps you need to regain full access to Excel spreadsheets. How to remove a password from a protected Excel worksheet.BEFORE you start Always make a backup copy of your spreadsheet. While the following steps will do nothing to the data in your spreadsheet, it NEVER hurts to be cautious and have a copy of your original document – “just in case…”. Step 1 Rename the extension of your spreadsheet from *.xlsx to *.zip. Step 3 Locate the “xl” folder and then the “worksheets” folder. Inside the “worksheets” folder you will see a list of all your worksheets within your spreadsheet. They will be listed as sheet1.xml, sheet2.xml and so on. Step 4 If you have a lot of worksheets within your spreadsheet, then this next step can get a little tedious… Starting at sheet1.xml – open the file in Notepad and search for the line that begins with “<sheetProtection algorithmName=”SHA-512″ hashValue=“. It will look something like: Nb: the hashvalue and saltvalue WILL be different in your file than what is shown here. Select this entire line – everything between and including the “<” and “>” characters and delete it. Step 5 Save your modified xml file. Repeat this process for every xml file in your spreadsheet. Once complete, you simply need to add your modified xml files back into your “zip” file, overwriting all existing original xml files. (To add your modified files back into your Zip file – ensure you have 7-Zip still open and navigate your way through to where the xml files are stored – i.e. go to the xl folder and then the worksheets folder. Then from your desktop (or wherever you have the modified xml files stored), select ALL your xml files and left click (and hold) and drag and drop the files from the desktop over into the 7-Zip folder.) Step 6 Rename your *.Zip file back to *.xlsx and “tadaaaaaa!!” all your worksheets will now be unprotected and you’ll have full access to your data and information stored in them. ExcelSuperSite Ultimate GuideHow to Unprotect an Excel Spreadsheet (when I have forgotten the password)Still stuck trying to unlock your spreadsheet. Download our Ultimate Guide to follow the very same, simple to understand and follow, step-by-step methods we use here at ExcelSuperSite to help our clients. How to Unprotect an Excel Spreadsheet (when I have forgotten the password)
If you do not want to potentially wait a long time to find your password with desktop password recovery software or you need to remove an Excel password using a Mac, another option you have is to try an online service instead. Online password recovery services claim to be a more swift and efficient way to deal with forgotten passwords. As the password recovery service is all done on their servers (with no installation required at your end), it does not matter what platform you are using (Windows, Mac OS, Linux) or even mobile devices (Android, iPhone, Windows mobile). As with most password recovery methods, these services do come with a fee. However, there is a difference in what you are actually paying for. In the case of desktop software solutions, you are paying for the software itself which then allows you to set the search parameters to try and find your password. The length of time it takes to recover a password is largely dependant on the speed of the computer you are running it on. Online services, on the other hand, do the heavy-lifting for you instead. You supply the protected file and everything else is done by the service. This way you are paying only for the successfully recovery of your spreadsheet password. Some online services even provide a demo for their services so you can be sure your file can be unlocked before you pay anything. The following steps outline how to use the online password recovery service Password-Find. To begin, click the following button or go to online service Password-Find on Password-Find.com From the home page click Unprotect your file. This will take you through to the file upload page where you can upload your spreadsheet to the service. After clicking Next Step you need to select a password remove or find approach. A free demo is only available for the Remove password approach, so choose that one to start with as you have nothing to lose in trying it. Once you click the Next Step button, the service will try to remove the password from your spreadsheet, which usually takes from a few seconds to a couple of minutes depending on the password strength. Once complete, you will be able to see the results of the unprotection process. If your spreadsheet is very small, it may be even fully unprotected for free. Otherwise, you’ll see this page. If successful, you will be able to download or view a demo-file, containing the first few rows of all the worksheets within your file. This demo-file is provided so you can check to be sure your spreadsheet has been unlocked. You can buy a license, to download your full document, only after you’ve viewed the demo-file and are sure your spreadsheet is unprotected and contains the information you need. You can try this service out by clicking the button below.
Help support ExcelSuperSite to continue to share content such as this.
Having Trouble and Need some help?Have you followed the steps outlined above, but are still having trouble restoring full access to your worksheet? We can help you! Since writing this article we have received many, many requests for help from people needing to remove the passwords from their spreadsheets. To request our help, please click the following link: Click here to request help from ExcelSuperSite Continue the DiscussionHave you had to remove the password from a protected worksheet? If so, how do you do it? Did you use a similar method to the above or another method? Continue the discussion and add your thoughts in the comments section at the bottom of this article. Please ShareIf you liked this article or know someone who could benefit from this information, please feel free to share it with your friends and colleagues and spread the word on Facebook, Twitter and/or Linkedin.
Some of our most popular downloads are … |
How to remove password Protect an Excel file
zusammenhängende Posts
Urheberrechte © © 2024 wiewird Inc.
