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

Get FREE Advanced Excel Exercises with Solutions!

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


Protect Workbook Not Working in Excel!(2 Simple Steps to Solve)

  • 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


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.


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.

Read More: Protect and Share Excel Workbook


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


Download Practice Workbook

Password to Unprotect the workbook is: 1234


Conclusion

Suffice it to say, that 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.


Related Articles


<< Go Back to Protect Workbook in Excel | Excel Protect | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Meraz Al Nahian
Meraz Al Nahian

Md. Meraz Al Nahian has worked with the ExcelDemy project for over 1.5 years. He wrote 140+ articles for ExcelDemy. He also solved a lot of user problems and worked on dashboards. He is interested in data analysis, advanced Excel, statistics, and dashboards. He also likes to explore various Excel and VBA applications. He completed his graduation in Electrical & Electronic Engineering from Bangladesh University of Engineering & Technology (BUET). He enjoys exploring Excel-related features to gain efficiency... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo