Why Does My Excel Spreadsheet Become Unprotected When I Upload It

If you lot've lost your protected worksheet password, yous'll need a mode to unprotect that Excel sheet and become access again. Hither's how to recover that protected Excel sheet.

When people create an Excel spreadsheet they don't want people to change, they'll oft protect private sheets. Protecting an Excel worksheet involves creating a password that you need to enter to make changes to the sheet.

There are several means to unprotect an Excel sheet like this. The get-go is obviously typing the password and unprotecting the sheet. Simply if you've forgotten the password or the person who locked it didn't requite the password to you, you aren't out of luck. There are two other ways to unprotect that sheet.

Unprotect an Excel Sail with the Countersign

The easiest way to unprotect an Excel sheet is if you know the countersign.

1. Click on the Review tab.
2. Select "Unprotect Canvas" in the Protect section of the card.
3. Type the password in the Unprotect Sheet dialogue window.

Unprotect an Excel Sheet with Google Sheets

Forgetting or losing the countersign on a protected Excel worksheet tin can exist scary. Your outset thought may exist that you've completely lost all the data in the sheet.

The proficient news is that at that place's a artistic workaround that allows you to unprotect an Excel sheet. You'll need a Google Drive account to do this.

1. Open your Google Bulldoze account, select New and select Google Canvass to open a new canvas.
2. In the sheet, select File and select Import.
3. In the Import file dialogue box, select Upload from the menu.
4. Click Select a file from your device.
5. Browse the Excel spreadsheet on your computer. Select it, and click Open.
6. In the Import file window, select Supplant spreadsheet and select Import Data.

This will import the protected Excel worksheet into your Google Sheets worksheet. Except, at present y'all'll observe that the sheet is no longer protected. You lot can edit it all you lot like.

At present that it's unprotected, y'all can export the sheet back to Excel format once again.

1. In the now unprotected Google Sheet, select File and Download every bit
2. Select Microsoft Excel (.xlsx)
3. Select Save As.
4. Give the file a name and select Salve.

Now you have the aforementioned Excel sheet, but the protection is removed.

Unprotect an Excel Sail with VBA

If you don't have a Google Drive account, or y'all're looking for another approach to unprotect an Excel canvas from within Excel, VBA is a swell way to practise it.

The idea is to introduce a VBA module that will crack the password one graphic symbol at a time. Depending on how complex the password is, the script can have from 10 minutes up to hours to run.

Step 1: Save every bit Older Excel File

The merely limit to this method is that it only works on Excel worksheets in Excel 2010 or older. This isn't a problem, and then long as you relieve the protected worksheet to an older version.

Just click File and Save Equally. For the format dropdown, select Excel 97-2003 (*.xls).

It'southward a hurting to take to salve to an older format, just the benefit is that one time the VBA script is done, the password is cracked, and you accept access to the unlocked sheet.

Footstep 2: Create and Run VBA Code

Here'south how to set up that VBA module.

1. Select the Developer carte particular in your ribbon. If it's not there, click File > Options > Customize Ribbon, switch Choose commands from to All Commands, and move Developer from the left carte to the right one. Click OK when you're done.
2. In the Developer menu, select View Code from the Controls section of the ribbon.
3. Rick-click on Microsoft Excel Objects, select Insert, and select Module.

A well-known VBA script has been around for years that will pause the password and unprotect any worksheet.

Re-create the lawmaking below and paste it into the module:

              Sub PasswordBreaker()     Dim i As Integer, j Equally Integer, k Equally Integer     Dim fifty As Integer, m As Integer, n As Integer     Dim i1 Equally Integer, i2 Equally Integer, i3 As Integer     Dim i4 As Integer, i5 As Integer, i6 Equally Integer     On Error Resume Side by side     For i = 65 To 66: For j = 65 To 66: For k = 65 To 66     For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66     For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66     For i5 = 65 To 66: For i6 = 65 To 66: For north = 32 To 126          ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(thousand) & _             Chr(l) & Chr(chiliad) & Chr(i1) & Chr(i2) & Chr(i3) & _             Chr(i4) & Chr(i5) & Chr(i6) & Chr(due north)          If ActiveSheet.ProtectContents = False And so             MsgBox "Countersign is " & Chr(i) & Chr(j) & _                 Chr(1000) & Chr(l) & Chr(g) & Chr(i1) & Chr(i2) & _                 Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)                 Exit Sub          Finish If     Next: Adjacent: Side by side: Next: Side by side: Side by side     Side by side: Next: Next: Next: Next: Side by side End Sub                          

Next, press the Run push (dark-green correct arrow) to run the script.

This will run the new module you've created. It volition attempt to crack the sheet protect password one grapheme at a time. The script took seconds to crack the password during a test with just three unproblematic characters ("ABC").

The countersign displayed volition be capricious. Just printing OK, and your Excel spreadsheet is now unprotected over again. Test typing into a jail cell to confirm.

Since a elementary password takes a few seconds, a password that's longer and more complex may have up to a infinitesimal or 2. Just leave it running in the background until the message box comes up.

In one case your worksheet is unprotected, you lot tin resave it to the previous format you were using before you saved information technology.

Choosing Your Unprotect Method

All iii of these methods volition work fine, but it's best to beginning with the simplest and work your mode down the list. Ideally, you'll know the password, and you can unprotect the canvass simply by typing it in.

Only forgetting a protection password is very mutual, then hopefully, the terminal 2 methods listed higher up will aid become you out of a jam and allow you edit your worksheet again.

ricetickincers.blogspot.com

Source: https://www.groovypost.com/howto/unprotect-microsoft-excel-sheet/

Share this post