1 00:00:01,460 --> 00:00:07,190 In this lecture, we are going to see how we can remove seed and viable protection from actual seeds. 2 00:00:08,500 --> 00:00:13,480 In the previous lectures, we have seen how we can correct Excel file passwords and how we can remove 3 00:00:13,480 --> 00:00:14,830 the read only section. 4 00:00:15,940 --> 00:00:21,940 In this lecture we are going to see how we can remove the protection from Excel sheets and the workbook 5 00:00:21,940 --> 00:00:22,750 protection. 6 00:00:25,870 --> 00:00:28,900 Let's first see how we can remove seat protection. 7 00:00:30,990 --> 00:00:34,020 You can protect a sheet from the review tab in Excel. 8 00:00:34,050 --> 00:00:37,110 A protected shield limits any modification in the sheet. 9 00:00:37,770 --> 00:00:41,130 Go to the View tab and then select the option to protect, cheat. 10 00:00:41,460 --> 00:00:42,540 Give it a password. 11 00:00:44,190 --> 00:00:46,170 No change the file extension to zip. 12 00:00:48,620 --> 00:00:51,680 Open the Z folder in Windows Explorer or Winrar. 13 00:00:54,380 --> 00:00:59,540 Look for the sheet file in the worksheet folder and open it in the text editor. 14 00:01:02,730 --> 00:01:07,810 Research for the content, sheet protection and above all contents within the given tags. 15 00:01:13,550 --> 00:01:18,860 Save the file separately with the same name and then drag it to the actual archive and replace the original 16 00:01:18,860 --> 00:01:19,370 file. 17 00:01:22,930 --> 00:01:28,240 No change back to file extension to excel file and your sheet protection will be removed. 18 00:01:32,110 --> 00:01:32,470 No. 19 00:01:32,470 --> 00:01:35,050 Let's see how we can remove the protection. 20 00:01:37,280 --> 00:01:40,520 You can protect a workbook from the review tab in Excel. 21 00:01:40,590 --> 00:01:44,300 Updated Workbook limits any modification in the sheet structure. 22 00:01:46,020 --> 00:01:50,580 You cannot add or delete shoes, you cannot hide or unhide shades. 23 00:01:51,030 --> 00:01:54,360 Go to the view tab and then select the option to protect the book. 24 00:01:54,390 --> 00:01:55,410 Give it a password. 25 00:02:00,850 --> 00:02:02,410 Jane, the file extension does a. 26 00:02:09,139 --> 00:02:11,780 Open the Z folder in Windows Explorer or Winrar. 27 00:02:17,640 --> 00:02:22,200 Look for the workbook doc xml file indexer folder and open it in a text editor. 28 00:02:25,140 --> 00:02:29,850 Search for the content vegetable protection and remove all the contents within the tags. 29 00:02:30,950 --> 00:02:35,510 They'll save the file separately with the same name and then drag it to the actual archive and replace 30 00:02:35,510 --> 00:02:36,470 the original file. 31 00:02:38,200 --> 00:02:42,160 No change Back to file extension and your sheet protection will be removed. 32 00:02:43,940 --> 00:02:44,300 No. 33 00:02:44,300 --> 00:02:45,110 Let's see that. 34 00:02:45,110 --> 00:02:46,220 Your demonstration. 35 00:02:49,150 --> 00:02:52,570 First of all, create a new shoot and write something in it. 36 00:02:53,800 --> 00:02:56,620 We'll go to review tab and click Protect Sheet. 37 00:03:00,750 --> 00:03:01,850 I gave it a password. 38 00:03:07,420 --> 00:03:08,620 Most of the file. 39 00:03:11,970 --> 00:03:14,580 Ensure that you saved in XLS format. 40 00:03:17,090 --> 00:03:19,760 Now to check whether our sheet has been protected. 41 00:03:19,970 --> 00:03:24,080 Open the file and you can see that the shooters logged. 42 00:03:30,900 --> 00:03:32,830 Well, Jane, the fight extension zip. 43 00:03:37,980 --> 00:03:38,550 No right. 44 00:03:38,550 --> 00:03:41,250 Click it and open it with Windows Explorer. 45 00:03:43,810 --> 00:03:45,220 Go to Excel folder. 46 00:03:46,710 --> 00:03:50,870 This huge folder and you can see a file sheet XML. 47 00:03:52,370 --> 00:03:52,620 No. 48 00:03:52,640 --> 00:03:54,380 Drag this file to the desktop. 49 00:03:56,130 --> 00:03:57,570 Open it with a text editor. 50 00:04:02,950 --> 00:04:04,470 So I shoot production. 51 00:04:11,320 --> 00:04:14,530 Remove all the content between sheet protection tax. 52 00:04:20,470 --> 00:04:21,459 Save the file. 53 00:04:24,510 --> 00:04:26,520 And drag the file to the original folder. 54 00:04:32,440 --> 00:04:34,360 The file extension to extend file. 55 00:04:36,820 --> 00:04:40,210 Open it and you can see that she put the remote. 56 00:04:46,790 --> 00:04:49,160 Logo activate the workbook protection. 57 00:04:50,780 --> 00:04:55,760 You can go to the review tab and select the protection and give it a password. 58 00:04:59,900 --> 00:05:00,710 We'll save it. 59 00:05:02,340 --> 00:05:05,910 Once you open it, you will see that you cannot add or delete and shoot. 60 00:05:06,330 --> 00:05:09,000 You cannot also hide or hide any shoot. 61 00:05:12,900 --> 00:05:13,880 Close the file. 62 00:05:17,110 --> 00:05:18,690 Jane Doe extension back to the. 63 00:05:21,280 --> 00:05:22,960 Open it with Windows Explorer. 64 00:05:28,100 --> 00:05:29,450 Go to Excel folder. 65 00:05:30,290 --> 00:05:32,840 And here we have got a XML file. 66 00:05:33,770 --> 00:05:35,270 Drag the file to the desktop. 67 00:05:36,820 --> 00:05:38,680 I look for protection. 68 00:05:41,870 --> 00:05:42,000 No. 69 00:05:42,080 --> 00:05:45,380 Remove all the content between workbook production tags. 70 00:05:47,560 --> 00:05:48,310 Save it. 71 00:05:50,250 --> 00:05:51,900 Drag the file to the original folder. 72 00:05:55,670 --> 00:05:57,740 Login to file extension back to Excel. 73 00:06:01,380 --> 00:06:02,110 Nobody. 74 00:06:06,780 --> 00:06:09,750 And you can see that our protection has been removed. 75 00:06:15,260 --> 00:06:18,320 I hope you like this lecture and see you in the next lecture.