[Fixed!] Protect Workbook in Excel Not Working (with Quick Solution)

The article will show you how to solve the Protect Workbook feature not working in Excel. You can protect your Excel sheet or workbook so that anyone other than you cannot make any changes to it. But it may not work if you don’t use the proper File Extension.
In the dataset, we have a .csv file that contains sales information of a store in a week. We will apply for protection on this file.

protect workbook in excel not working


Download Practice Workbook

Password to Unprotect the workbook is: 1234


2 Simple Steps to Resolve the Issue: Protect Workbook in Excel Not Working

  • Open the file with .csv extension. You will see that the file will open without requiring any password. There will be a loss of some formats too.

protect workbook in excel not working

Step-1: Save the File Using Save As Feature 

  • To make the Protect Workbook feature work, go to File >> Save As
  • Choose the marked drop-down icon and select Excel Workbook (*.xlsx). Change the name of your file if you want.
  • Click on Save.

  • Now, change the format of your data from the workbook according to your convenience.

protect workbook in excel not working

Read More: How to Protect Excel Workbook from Editing (5 Effective Methods)


Step-2: Making Protect Workbook Work Using Excel Info Feature

  • Go to File >> Info >> Protect Workbook >> Encrypt with Password

  • A dialog box will show up. Put a password and then Reenter to confirm
  • After that, click OK.

protect workbook in excel not working

  • Save the workbook before closing it or just press CTRL + S and then Close the workbook.

  • Now, open the workbook that has the .xlsx extension. You will see it will require the password that you added to the workbook. Insert the password and click OK. In case you want to open my workbook, use the password 1234.

protect workbook in excel not working

  • After that, you will see the protected data of the workbook.

Thus you can solve the issue of workbook protection not working on an Excel file by inserting the proper File Extension.

Read More: Protect and Share Excel Workbook (2 Quick Methods)


How to Properly Protect Workbook with CSV Extension in Excel

You need to apply for protection first. To do this,

  • First, go to File >> Info >> Protect Workbook >> Encrypt with Password

  • A dialog box will show up. Put a password and then Reenter to confirm
  • After that, click OK.

protect workbook in excel not working

  • Save the workbook before closing.


Practice Section

Here, I’m giving you the dataset of this article so that you can make a .csv file on your own and then be able to protect the workbook with a password.

protect workbook in excel not working


Conclusion

Suffice to say, this article shows you the necessary steps to solve Protect Workbook in Excel not working. If you have any other ideas or feedback regarding this article, feel free to share them in the comment box. This will help me enrich my upcoming articles. To get familiar with more basic knowledge about excel, visit our website ExcelDemy.com.


Related Articles

Nahian

Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo