New Exel 2010 writes that the file is corrupt and does not open xls! How to be and what to do? Microsoft version Office Exel 2010 14.0.6123.5001
Although I absolutely know that the file is normal - after all, Open Office - it opens. It so happens that the file is automatically created by the script - and Exel writes that: What to do in this case? To me as a user - to clutch my head or still figure out what is the cause of embarrassment. It is known that quite a few viruses are written for Microsoft Office, including those with support for the built-in vb-scritp simplifying the procedure. And for this, in the new "Office", the developers ticked off, rather unchecked the support, as they consider - "old" files. And we - turn it back on
- all the old support. To do this, go to: File - Settings - Settings - Trust Center - Trust Center Settings and then look at the pictures, how it looks in action: 
Well, first of all - we allow the opening of so-called "unknown" files from the network. Who cares - but I don’t understand it! Those. cancel work with a security certificate - and allow everything. Or if you have a company, we buy a certificate of thousands for 100 rubles and put it in a folder on network resource - where the xls files should lie (i.e. where we are downloading from) Or just remove the dot. Now photo number 3. Check the box here - support all xls formats. And including 97 years. It's about “opening files” this column. Yes, and I advise you to experiment with the security settings in these tabs!
Something to resolve, but something "critical" is not. (For example, running scripts or opening a file through OpenOffice) That's all. Click OK! And open the file again - xls opened
, but now the inscription of the firewall dominates at the top: Modifying files of this type is prohibited by security policy.... Here's what Microsoft writes about this jamb, about which for some reason no one knows until now:
But sometimes this can cause problems if text Document damaged. These error messages indicate corruption and let users know about it. The following is a list of the most common error messages. In such a situation, a valid backup file acts as a life saver for you. The steps used to complete this technique are as follows. This trick can fail if corruption is severe. In this case, you can switch to another trick.
"Recover text from any file" Word Converter
You can also open this function in the Open dialog box. If this trick also fails due to severe corruption, you can try another manual trick.
Insert damaged document into new
There is one more trick you can use.Why does the file open in protected view?
Protected View is a read-only mode in which most editing features are disabled. There are several reasons why a file is opened in protected viewing mode.
- The file is open from a location on the Internet. This file is downloaded from the Internet and may be insecure. Click for more information., this is due to the fact that the opened file is received from the Internet. Such files may contain viruses and other malicious content. Opening a document for editing should only be done if you trust its contents. The figure below shows an example.
- The resulting file is an Outlook 2010 attachment, and the sender of the message is considered unreliable in accordance with the policy set on the computer. If in protected mode the message This file is originally received as an attachment is displayed email and may be unsafe. Click for more information. , this is due to the fact that the file was received from a potentially unsafe sender. The figure below shows an example.
- File opened from insecure location. If a message is displayed in protected view This file has been opened from a potentially unsafe location. Click here for details., the file was opened from a folder that is considered unsafe. An example of an insecure location is the temporary Internet files folder. The figure below shows an example.
- The file is locked by the file lock function. The figures below show examples.
Editing is prohibited.
Watch the online video tutorial below.
Did you receive the important presentation file as an email attachment? And get the error: "The file is damaged and cannot be opened" when trying to open this presentation file? This secure browsing feature is designed to protect documents downloaded from insecure sites.
But by disabling the Protected Browsing option, malware from other unknown sites can easily log in when downloading any file. Thus, you can solve the problem using the method below. You can easily resolve the error displaying the presentation files and make them work normally again with this tool.
Editing allowed.
- File verification failed. If in Protected View, the message Found a problem with this file. Editing can damage your computer. Click for more information. , this is because the file failed to validate. The figure below shows an example.
Note. For more information about file verification errors, see Problem with file.
How to fix the "file is corrupt and cannot be opened" error
If you are faced with such a terrible situation, please do not worry! The error message “the file is corrupted and cannot be opened” does not mean that your file is really corrupted or corrupted. No technical skills or professional knowledge, just 3 simple steps are required. Everyone can do it without difficulty!
Here you must save all recovered files to another drive to avoid overwriting data. In the Options window, select the last Trusted Center tab. In the new window, select Protected View. Go to the navigation bar and expand Component Services. Then go to the Computers section and expand it. You should definitely try all these options before moving on to third-party tools, etc. Both of the built-in recovery options mentioned above can be accessed through the Open File dialog box.
- The file is opened in protected view using the option. If a message is displayed in protected view This file was opened in Protected View. Click for more information., this is due to the fact that the file was opened using the command Open in protected view. To use this command, follow these steps:
- Open tab File.
- IN submission Microsoft Office Backstage press the button Open.
- In the dialog box Opening a document click arrow on the button Open.
- Select a command from the list. Open in protected view.
The figure below shows the protected viewing mode invoked with the command Open in protected view.
You will see a bunch of additional options, one of which. Always use this option first, as it does a pretty good job and requires no additional software. The second built-in function is the recovery converter, which you can also access through the Open dialog box.
In my case, this failed and only returned a message that the file looks corrupted. Depending on the type of corruption that your files have suffered, your results will vary. Again, your results will be different, so take a picture, but don't expect much. This method is a bit confusing, but it may work for you depending on the type of damage that your document supports. Basically, we create a document, paste the text into it, copy this text, then paste the special text into the new document as a link and, finally, update this link to indicate the damaged file, and not the source file.
Important. Administrators can expand the list of potentially unsafe locations by including additional folders that are also considered unsafe. (On the site, let's say it will be a security certificate worth a lot of money)
According to Microsoft Office Developers:
Microsoft Office 2010 has encountered a problem with the file, which may be security risk. To protect your computer, open the file in protected view. It is recommended to open it for editing only if its sender is trustworthy, and the file itself does not seem suspicious.
Now select the text you just printed and copy it to the clipboard. If you want, select a blank document. Here you must select and then select either formatted text or unformatted text. It doesn’t matter which one you choose. If you get any error message when you try to insert a link, close and close the new document, copy the text and create a new document again.
Now we are nearing the end. However, my test file was damaged in several ways, and this could be the reason that the text was not restored. You should try anyway. Another thing you can try is to open the file in draft mode, which does not look at the header information, etc. and therefore can open the file.
Reasons for this message
This message can be displayed for a malicious file that was created by an attacker to infect a computer with a virus or steal important data. It means edit given file can be dangerous. Sometimes this message is displayed for corrupted filesfor example in the following cases:
Go to and select the “Add space for notes” and “Use draft” checkbox in the “Drafts and Frames” window. Now try to open the damaged file and see if it opens. If not, you will have to continue reading others possible ways Correction of corruption.
This means that the "System Restore" function must be enabled, which is the default. If you disabled it manually, you will not be able to recover data using this function. If you do not see the tab, then system recovery does not turn on. All previously saved versions will be displayed in the list below. Obviously, you will lose all the data that was added after the last backup and before the error occurred, but it is still better than nothing.
- the disk on which the file is stored is faulty;
- the file was created or edited using a program with which some problems are associated;
- an unexpected error occurred while copying the file to the computer, which could be caused by a problem with the Internet connection;
- there was a problem with the file troubleshooting algorithm package Office 2010; we are trying to make it better, but it is not perfect. ( Of course of course 🙂)
I wrote how to fix all these situations in action - so that the file would still open if you have confidence in it - using a real example. (see screenshots of the program and settings)
Demonstrations usually allow you to see part of the text and tell you if you succeeded in restoring everything else. At this point, you can pay if you feel that the program will receive your results. You should also make sure that you make a copy of the damaged file before you start using the recovery tools. One program may ultimately corrupt the file, and a second program that may have been able to recover the original damaged file also cannot be caused by changes made to the first program.
Still idle microsoft program Word was the cause of continued efforts to rewrite information or completely lose information forever and many other troubles. Today this problem is solved, but many more know that a document that has been damaged can be repaired on its own using the simple steps to restore such files, presented below.
This is one of the few free apps, and there is a big reason for this. However, if you have a damaged file. The demo will also recover a small portion of the file to help you decide if it costs a lot. The program also gives you an assessment score of 1 to 3, the first of which is the least likely, and the latter has the highest probability of data recovery. In my case, I had 1 out of 3, and my file was completely unreadable.
It's also quite expensive, but again, you can download the demo and check the preview to see if data can be recovered. Once it is completed, it will show you a preview of any content that it could receive.
Why did the program stop working?
The reasons that the program Microsoft Word stopped working, maybe a huge amount. Among the most common are:
- Crashes in the operating system;
- Someone's joke;
- Local error in the document itself.
In the first case, it may be necessary to reinstall the program itself, and the information contained in the document (unless specifically deleted) may be preserved. But after reinstalling the files will work in normal mode, and the next text to be written will not be lost.
If nothing is displayed in the preview window or something is missing, return to step 2 and select the Use content search mode check box. It will find more content, but it will also create more garbage characters. In my test, this program also could not recover anything from my corrupt file.
Again, the demo version will try to recover some data from your file as proof that it really works. He will ask you to specify a place to save the recovered files and then start the recovery process. Again, this program failed while trying to recover text from my damaged file.
In the second case, the reason may be a desire to play a trick on one of the PC users or ill-wishers.
To do this, just click on the file with the right mouse button and select “Properties” in the list that appears.
In the properties, open the file in the format of the Notepad program and write extra characters in the text (it will be presented as codes). 
In fairness, my file was intentionally corrupted to the maximum. There are also many other paid programs that you can try, just be sure to download a trial version or demo before you buy. It all works, and it can be lost forever if you are not smart enough to do backup. First, you can try to restore and see if it can restore the entire file, if not, you can try to extract the data.
Method 2. Save the file in a different format
You will need to save each sheet separately and repeat this procedure.
Method 3 - Change the translation parameter
If you cannot open the file at all, you can try a couple more things. In the "Calculation" section, select "Manual." Even if you can open files, you lose chart sheets, dialog sheets, macro sheets, and you lose all cell formulas. However, you should be able to view the data.To restore a file, you can also try to open it and delete extraneous information, but this is possible if you can distinguish “necessary” characters from “unnecessary” ones. It is logical to assume that in this case the “enemy” letters will be written at the beginning of the text, but this is not necessary because they can be cleverly hidden in the middle or at the end of the text. Method 2 - through word file
Method 5 - Link to a damaged file
You will need to search for “Function” or “Sub”. If so, now you can simply drag the corner of the window and expand the selection to how many rows and columns exist in the corrupt book. All you can do is copy the cells and paste them into a new book, but this is better than nothing. As versions increase, the ability to recover a file also increases, so you may get lucky and recover your file.
If the drawing file does not open at all
At this point, we hope and pray, but it's worth it. The message “Invalid drawing file” or another message about detected errors during the opening process may appear on the drawing, or it may not respond or fail.
If the drawing file can still be opened
- Go to the “View” tab and enable the ability to view hidden files.
- Select the problem file.
- Select the problem file and see if it is inserted.
To use this method, do the following:
The program with the document will open intact.
Method 2 - Using Cimaware Officefix
If the previous two ways to open files for any reason were ineffective, or you immediately decided to act globally, use a special program.
If the drawing still causes problems, try the following:
- The insertion point is 0. 0.
- Save the new drawing.
- Make sure all layers are activated, thawed and unlocked.
- Solve all external links.
Cimaware Officefix is special program to repair damaged microsoft files Office You can download it on the official website cimaware.com or by searching on the Internet on almost any torrent tracker.
When the file loads, open it and do the following:
That's it, the file is restored and ready to use, and if it “breaks” again, you know what to do!
As a precaution, you should keep your book as often as you can and create a security scan for each storage process. Thus, you always have access to a working copy of the book if the original is accidentally deleted or damaged. Click the arrow next to the Open button, and then click Open and Restore. Do one of the following: Click Restore to recover as much of the book data as possible. If errors occur while trying to restore the workbook, click “Extract Data” to extract the values \u200b\u200band formulas from the workbook. If you are editing a workbook and the workbook is corrupted before you can save your changes, you can restore original book Returning to the last saved version. To restore the last saved version of a workbook: On the File tab, click Open. The workbook is reset to the last saved version. This will undo any changes that could damage the book. In the File Name box, enter a new name for the book to create a copy without replacing the original book, and click Save. Since in this format only the active worksheet is stored in the workbook, you must repeatedly open the damaged workbook and save each sheet separately. To manually open a book, change the calculation setting from automatic to manual. If the new, empty book is not open, proceed as follows.
- File to open.
- Click Yes to open the book.
- File, and then click Save As.
- On the File tab, click Open.
- On the File tab, click Save As.
- Since the workbook is not recounted, it can be opened.
