Apr 22, 2014 - A few possible workarounds for identifying which user has the file locked when they're just referred to as 'Another User'. How to unlock Excel Spreadsheet for editing when forgot password Lock the cells on your Excel spreadsheet and protect them with password can helps to prevent other users from accidentally and deliberately changing, moving or deleting the data on your Excel worksheet. However, if unfortunately, you won't be able to edit the protection part of worksheet too. Video card for mac g4. How to unlock an Excel spreadsheet for editing when forgot password? Here will show you 3 ways, and it is sure to help you get rid of this tiresome password problem. Applies to Excel 2007/2010/2013/2016. 3 ways to unlock password protected Excel sheet for editing: Way 1: Copy the data to another sheet to edit it When you forgot the password to unprotect Excel sheet to edit the data, first you can create a new sheet, then copy and paste the data to the new sheet to edit it. This way works only if the 'Select locked cells' and 'Select unlocked cells' actions are allowed in the protected sheet. Select all the data on the sheet that needs to be unlocked. Press 'Ctrl + C' to copy the contents. Click on the New sheet button to add a new sheet on the workbook, or press 'Ctrl + N' to create a new workbook. Press 'Ctrl + V' to paste the data on the new sheet. Now you can modify the data on the new sheet, and save them after editing. Tips: You can select 'Keep Source Formatting' under Paste Options, so that you don't need to adjust them in the new sheets manually. But if the protected sheet has external links to other sheets or workbooks, you need to add those links manually. Way 2: Unlock Excel sheet without password by Workbook Unprotect Tuner can help to remove Excel Worksheet, Workbook, Read-only protection password in two seconds no matter how long or complex the password is. To run Workbook Unprotect Tuner on your computer, first you need to download it, and install it. Click on the Open or Add file button, and them select the Excel file to import it into the program. Click on 'Remove Password' button. In two seconds, the Excel worksheet protection password is removed! Go to the folder where the Excel file is located, you will find a new Excel file with the same name but marked as 'Unprotected', click on this Excel file, you will find it is the same with the old one, and the protected sheet is editable. Tips: If the Excel file is also encrypted with opening password, remove the Excel file encrypted password first. If you forgot the Excel opening password too, go and see how to recover password when. Way 3: Use VBA code to unlock the locked Excel sheet This way works on Excel spreadsheet 2007 and earlier version. My 'landscape' page did not have any footer, neither did the page right after it, but the second 'portrait' page from the landscape one started from 'O'. Check that the sections after the landscape page have not been affected. Select 'Continue from previous section' radio button. If they have, repeat the procedure for those sections. Word for mac 2011 footnote goes to next page. I faced the same problem and this is how I solved it. Open the Excel file, and press 'Alt + F11'. Click on Insert, select Module.
0 Comments
Leave a Reply. |