1
00:00:00,390 --> 00:00:04,980
In this lecture, we are going to see how we can unlock read only Excel files.

2
00:00:06,850 --> 00:00:09,760
The first step will be a password protected Excel file.

3
00:00:10,000 --> 00:00:15,370
You can give a password to an Excel file by going to properties and in the security tab you can apply

4
00:00:15,370 --> 00:00:17,710
a password that limits modification.

5
00:00:18,220 --> 00:00:18,610
No.

6
00:00:18,610 --> 00:00:20,800
Change the file extension to a zip file.

7
00:00:25,620 --> 00:00:28,950
Open the Z folder in Windows Explorer or Winrar.

8
00:00:34,400 --> 00:00:40,310
Now look for the workbook dot XML file in the Excel folder and open it in a text editor.

9
00:00:42,960 --> 00:00:47,490
Search for the content, file sharing and remove all contents within the tag.

10
00:00:53,040 --> 00:00:53,190
No.

11
00:00:53,280 --> 00:00:59,340
Save the file separately with the same name and then drag it to the actual archive and press the original

12
00:00:59,340 --> 00:00:59,820
file.

13
00:01:04,050 --> 00:01:05,670
Let's see that connection.

14
00:01:09,610 --> 00:01:11,440
First of all, create an Excel file.

15
00:01:13,870 --> 00:01:14,170
Right.

16
00:01:14,200 --> 00:01:15,310
Some content in it.

17
00:01:18,550 --> 00:01:19,270
Click Save.

18
00:01:22,480 --> 00:01:23,740
Now while saving.

19
00:01:24,810 --> 00:01:29,280
Go to both general options and give it a password to modify.

20
00:01:31,950 --> 00:01:35,820
Remember, this attack works only on the password to modify.

21
00:01:36,420 --> 00:01:39,960
We have already seen many attacks to correct the file opening password.

22
00:01:43,200 --> 00:01:44,310
Once saved.

23
00:01:45,030 --> 00:01:47,940
You can open the file and see that it's password log.

24
00:01:53,480 --> 00:01:54,170
Close it.

25
00:01:58,130 --> 00:01:58,820
No, Jane.

26
00:01:58,850 --> 00:02:00,340
The extension of the file to the.

27
00:02:01,690 --> 00:02:08,650
If you don't see your extensions, we can go to you and select the option to show file extensions.

28
00:02:11,150 --> 00:02:13,000
They'll change the file extension to zip.

29
00:02:18,110 --> 00:02:18,530
No.

30
00:02:18,530 --> 00:02:19,420
We have a book.

31
00:02:19,430 --> 00:02:20,990
One zip archive.

32
00:02:22,020 --> 00:02:22,530
Just right.

33
00:02:22,530 --> 00:02:25,470
Click the archive and open it with Windows Explorer.

34
00:02:29,060 --> 00:02:30,650
Now go to Excel folder.

35
00:02:33,120 --> 00:02:36,030
And here you can see a workbook XML file.

36
00:02:38,570 --> 00:02:40,730
No, just drag it to your desktop.

37
00:02:42,260 --> 00:02:43,910
Open it with the notepad.

38
00:02:47,480 --> 00:02:49,010
No press control f.

39
00:02:51,930 --> 00:02:53,370
And search for file sharing.

40
00:02:56,560 --> 00:03:00,330
Delete all the content that is included in file sharing tags.

41
00:03:10,070 --> 00:03:11,120
Save the file.

42
00:03:16,270 --> 00:03:18,100
Drag the file back to the archive.

43
00:03:19,830 --> 00:03:20,850
Click replace.

44
00:03:26,140 --> 00:03:29,800
They'll change the archive extension back to Wexler's X File.

45
00:03:33,530 --> 00:03:34,320
Open it.

46
00:03:37,850 --> 00:03:40,460
And here you can see that our password has been removed.