Fix Excel file error when Open and Repair function is not working

Your Excel file is corrupted but the Open and Repair function (opening and repairing) does not work. Follow the instructions below to recover your data!

Whether you are a student, student, or business person, you need to work with Excel. Microsoft Excel helps you do a lot of tasks such as setting goals, creating budgets, analyzing data, calculating wages, etc. Most of us use this software and trust it to calculate and solve problems. The most difficult topic. However, like other software, Microsoft Excel sometimes fails, even leaving you unable to access important data files.

The best way to avoid data loss when a Microsoft Excel file is corrupted is to take some proactive protection measures, such as making a backup of files and creating an automatic restore file periodically. If the Excel file is corrupted, you can use the " Open and Repair " function provided by Microsoft Excel itself. But what to do when even this function does not work?

Fix Excel file error when Open and Repair function is not working

This is a question posed by millions of Excel users worldwide. Sometimes the Open and Repair function stops working for some reason. In this case, some people will not know how to repair and restore their files like!

In this article, Tip.download.vn will provide you with solutions to this problem. If Microsoft Excel's Open and Repair function does not work, read the next section and follow to recover the corrupted Excel file successfully.

How to repair an opened Excel file

If your workbook is open in Excel, users have 2 options to recover data. It is best done the first way. If that fails, move on to option 2.

Method 1: Return to the spreadsheet in the version saved before the error

  • Open Excel and click File -> Open
  • Select the corrupted file and open it.
  • Click Yes to save the copy of the workbook that was saved before the error.

Important note : If you use this method, you will lose everything that was done on the file after it crashed.

Method 2: Save the spreadsheet in SYLK file format

  • Open Excel and click File -> Save As
  • In the Save as Type field , select YLK (Symbolic Link) from the drop-down menu and click Save .
  • To save only the active sheet in a spreadsheet, click OK . The system will display a notice that this sheet has features that are not compatible with the SYLK format.
  • Click Yes .
  • In Excel, click File -> Open .
  • Select the file and you saved in SYLK file format and open it.
  • Continue to File -> Save As .
  • In the Save as Type field , select Excel Workbook from the drop-down menu.
  • In the File Name field , enter a new name for the worksheet and click Save .

The SYLK file format will filter out corrupted elements from your spreadsheet, through which the data will be restored.

Important note : Using this method, you can only salvage the active sheet in the worksheet.

Fix Excel file error when Open and Repair function is not working

How to fix an Excel file that cannot be opened

In this case, there are two options for data recovery. Try the first one, if it doesn't work then go to method 2.

Method 1: Set the Manual calculation option

  • Open Excel, click File -> New
  • From the Available Templates window , select Blank workbook
  • Click File -> Options .
  • On the Formulas tab , in the Calculation options section , click Manual .
  • Choose OK .
  • Go to File -> Open .
  • Select the corrupted file and open it.

The system will open the corrupted file. It can open since the worksheet is not counted.

Method 2: Link the spreadsheet to external references

  • Open Excel and click File -> Open .
  • Copy the name of the corrupted file and click Cancel .
  • Choose File -> New .
  • From the Available Templates window , select Blank workbook .
  • In the new worksheet, on cell A1 type the following:

= File name! A1

  • In particular, "File name" is the name of the corrupted file.
  • In the Update Values dialog box , select the sheet and click OK .
  • Select cell A1. Select the cells in the same row and column as the cells containing the data in the corrupted sheet, including cell A1.
  • On the Home tab , in the Clipboard section , choose Paste .
  • While the rows and columns remain selected, select Copy .
  • Choose Paste .
  • In Paste Values , select Values .

Note : This method allows you to only recover data and not recover values ​​and formulas from a spreadsheet.

Alternative methods.

In addition to the above, you can also use extended commands (macros) to extract data from an error spreadsheet. However, this method is risky and implementers also need technical knowledge.

Therefore, if the above methods do not bring the desired results, a quick and easy way to fix the corrupted Excel file is to use Stellar Phoenix Excel Repair software . This software is the best choice to repair corrupted Excel files and restore everything to a new Excel file. Stellar Phoenix Excel Repair allows you to restore tables, charts, annotations, photos, formulas, organize and filter data from corrupted spreadsheets and also allows you to repair multiple Excel files at once.

I wish you successful implementation!

Sign up and earn $1000 a day ⋙

Leave a Comment

Pros and Cons of Enabling VPN at the Router Level

Pros and Cons of Enabling VPN at the Router Level

While many of us use VPNs directly on our devices, you can also enable VPNs at the router level. This setup eliminates the need to connect each device individually.

Dont buy these 5 smartphone photography gadgets!

Dont buy these 5 smartphone photography gadgets!

Buying a lot of add-ons may make you feel more professional, but buying the wrong thing won't improve your photography.

Thinking there was no way out, the wildebeest unexpectedly defeated the lion

Thinking there was no way out, the wildebeest unexpectedly defeated the lion

A video shows a wildebeest being held down by a lion. It seems the antelope’s fate has been sealed, everyone thinks it is just waiting to die.

Heart-Healthy Snacks

Heart-Healthy Snacks

Choosing heart-healthy snacks can add extra nutrition to your diet and help keep you energized and full between meals.

Simple way to fix computer suddenly shut down

Simple way to fix computer suddenly shut down

If unfortunately, you are using the computer and suddenly it turns off. You are wondering what is wrong with your computer? This article will guide you how to fix this error.

How to delete reading list on Safari

How to delete reading list on Safari

Over time, as you use your reading list in Safari more often, it can get large and cluttered. Here's how to clear your reading list in Safari.

How to create a Telegram group topic for discussion

How to create a Telegram group topic for discussion

Telegram group topics will be separate from messages in the Telegram group and you can create many different discussion topics. The article below will guide you to create Telegram group topics.

Tesla coil can discharge electricity and sing

Tesla coil can discharge electricity and sing

The Tesla coil is a resonant transformer circuit, a famous invention of the brilliant genius Nikola Tesla. It is used to produce high voltage, low intensity, high frequency alternating current... Not only discharge electricity, with intelligence and creativity, people also make Tesla coils sing.

Moving a 220-ton ancient building with 700 bars of soap

Moving a 220-ton ancient building with 700 bars of soap

In early December, construction company S. Rushton successfully moved an ancient building weighing up to 220 tons in Halifax, Nova Scotia, Canada, a distance of 9 meters with the "help" of about 700 bars of soap.

Supersonic engine reaches speed of 19,756 km/h

Supersonic engine reaches speed of 19,756 km/h

Chinese hypersonic weapons researchers create the world's most powerful rotary-explosive engine that allows aircraft to travel at 19,756 km/h (Mach 16) at an altitude of 30 km.

Status to wish yourself a happy birthday in English

Status to wish yourself a happy birthday in English

Below are some statuses to wish yourself a happy birthday in English, happy birthday wishes in English for yourself that are good and meaningful, please refer to them.

1 liter equals how many ml, kg, m3?

1 liter equals how many ml, kg, m3?

How many ml is 1kg? How many kg is 1ml? Let's learn how to convert these units of weight!

AI animal translation helps humans understand dog barking

AI animal translation helps humans understand dog barking

Thanks to artificial intelligence (AI), what seems like a movie dream - humans being able to understand animal language - may soon become a reality.

What do the camera settings on your phone do?

What do the camera settings on your phone do?

Knowing what each feature does can make the difference between a good photo and a great photo.

CapCut Pro Price: How Much Does CapCut Cost? Choosing the Best Version for You!

CapCut Pro Price: How Much Does CapCut Cost? Choosing the Best Version for You!

Discover the CapCut price, features of the free and Pro versions, and a detailed comparison to help you decide which CapCut subscription is right for your video editing needs.