How to Repair a Virus Infected Excel File?

Microsoft Excel, a spreadsheet application, offers Calculation, Graphing tools, Pivot tables, Macro programming language called Visual Basic for Applications (VBA), etc. it has become an irreplaceable application for users. Individuals and enterprises widely use it for trading, accounting, scientific work, Sales & Marketing, etc. However, neither its Mac nor Windows version is resistant to virus infection. Viruses may anytime infect it, thus leading to corrupt or damaged Excel file. In such a situation, it becomes necessary to know how to repair a virus infected Excel file.

A Virus that Can Corrupt MS Excel File

Macro/VBA virus is a malware that comes in several forms such as PLDT, CAR, and SGV. It can infect any application written with a Macro language and MS Excel is one of them. Here in Excel, it takes advantage of Macros by attaching itself to the file and secretly takes over the Auto_Open function of Excel. It does exactly what its name recommends. The easiest way in which you can defend yourself against PLDT/CAR/SGV Macro viruses is by disabling Macros in the Excel files.

Ways to Repair Virus Infected Excel File

What if the Excel files have been infected with a virus? In such a situation, you need to repair and restore them successfully. Here are the top 5 ways to repair virus infected Excel files and restore them without making any changes to the data within.

  • Method 1: Repair method

If the MS Excel does not start the File recovery mode automatically, try to repair the virus infected Excel file manually with the Repair method. To do so, follow the steps mentioned below:

  1. Click on the Microsoft Office button, and then on the Open.
  2. In the Open dialog box, select the corrupt Excel file you wish to open.
  3. Click the arrow next to the Open tab and then on the Open and Repair
  4. Execute one of the following two:
    • Click on the Repair tab. (Do so to recover as much data of Excel file as possible)
    • Click on the Extract Data tab. (Do so to extract values and formulas from the Excel file when an attempt to repair the file is unsuccessful.)
  •  Method 2: Open with Open Office

Open the corrupt or damaged Excel file in Open Office that is an open-source Office suite, capable of opening and saving Excel files.

  • Method 3: HTML method

Open the Excel file and save it in HTML format. By doing so, the damaged elements may get filtered. Thereafter, the filtered out elements can be discarded. 

  • Method 4: SYLK Method

Open the Excel file and after that save it in SYLK format. By doing so, the damaged elements may get filtered. After that, discard the filtered elements to repair and restore the infected Excel XLS or XLSX file. 

  • Method 5: Use A Third-Party Tool

Try using a third-party tool that can easily repair damaged or corrupt Excel files and restore every bit of information easily and quickly. For instance, you can use Stellar Phoenix Excel Repair. You can also search for similar tools having the capability to repair and restore damaged Excel files.

 Why Use Stellar Phoenix Excel Repair?

As Stellar Phoenix Excel Repair provides a number of benefits, this tool is recommended. The benefits that it provides are as follows:

  • Repairs virus infected Excel files.
  • Can fix all errors in MS Excel files.
  • Can repair one or more Excel files in one go.
  • Recovers table, chart, cell comment, and other components.
  • Conserves properties and cell formatting of Excel files.
  • Available for both Windows and Mac systems.
  • Supports MS Excel 2016, 2013, 2010, 2007, 2003 & 2000 versions.

 Conclusion

Now that you know the five ways to repair a virus infected Excel file, you can try any that befits your needs and requirements; however, it is recommended to use the Safe, Secure & Reliable Stellar Phoenix Excel Repair for satisfactory results.

Leave a Reply

Your email address will not be published. Required fields are marked *