How to Repair Multiple Excel Files by Using Stellar

With Stellar Repair for Excel, it is quite easy and simple to repair multiple MS Excel (XLS and XLSX) files that are damaged. This is because the software has a self-explanatory interface and hence is a Do-it-yourself software. Nonetheless, when using this software to repair multiple Excel files, you would have to add all of the files into the software by following a few pre-defined steps. Follow the steps mentioned below:

• Launch Stellar Repair for Excel software.
• Under Home menu, click Select file

• Click Browse and select corrupt Excel files. Select the checkbox to repair multiple files.

• Click Repair
• The software provides the preview facility. You can check the it on left pane.

• Save the repired filr ether Default location or Select New Folder radio button.

Stellar Repair for Excel Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files. This Excel recovery software restores everything from corrupt file to a new blank Excel file.

Learn More

Data Disappears in Excel - How to get it back

Summary: You may face the issue of ‘Excel spreadsheet data disappeared’ after changing Excel file properties and formatting rows and columns. This blog discusses the possible reasons for data disappearance and the solutions to fix the issue. Also, it mentions an Excel file repair tool to retrieve the data from the file. Sometimes, while editing or formatting a cell in an Excel spreadsheet, the data may go missing or disappear. Let’s discuss in detail the reasons that may cause the ‘Excel data disappeared’ issue along with the solutions.

Probable Reasons for Data Disappearing in MS Excel and Solutions Thereof

Reason 1 – Unsaved Data

While entering data in an Excel spreadsheet, it is important to save the data at frequent intervals. Doing so prevents any unsaved data from disappearing if you lose power or accidentally click ‘No’ when prompted to save the file. Unfortunately, such a situation is quite common as users often close the file without saving the recently made changes to a spreadsheet.

Solution – Use the ‘AutoSave’ Feature

With the AutoSave feature enabled in Excel, data won’t be lost in the event of power failure or abruptly closing the Excel program. By default, Excel automatically saves the information in a spreadsheet after every 10 minutes. You can reduce the limit to a few seconds to reduce the chances of Excel file data lost after being saved.

Reason 2 – Changing Excel Format

You can save an Excel file in various formats, like spreadsheet, text, webpage, and more. However, at times, saving the spreadsheet in a different format may lead to missing data. For example, when you save a workbook to a text file format, all formulas and calculations applied to the data will be lost.

Solution – Adjust a Spreadsheet for the Changed Format

If you’re changing the format of a spreadsheet, make space for the rows and columns. Also, remove all calculations before saving the file.

Note: If the sheet is shared on multiple computers, then save the file in compatibility mode.

Reason 3 – Merging Cells

You can combine two or more cells data to make one large cell. This technique is primarily used to fit the text of a title in a sheet. If there is data in two or more cells, then only the data in the top-left cell is displayed and the data in all other cells is deleted. If the other merged cells have been populated with data after merging, the data is not featured and it does not appear even after remerging the cells.

Solution – Merge Cells inside One Column

To merge cells without data loss, combine all the cells you want to merge within a column and do the following:

• Select the cells to be combined.
• Ensure that column width is wide enough to fit the contents of a cell.
• In the spreadsheet, under the Editing group, click ‘Fill,’ and then click ‘Justify.’

• Under Alignment, click on the ‘Merge & Center’ option to center align the text. Or, click on ‘Merge Cells’.

Note: This solution works for text only. You cannot use it to merge formulas or any numerical values. If you need to combine two or more cells with formula into a single cell, try using the Excel CONCAT function .

Reason 4 – Cell Formatting

Cells and text in the cells can be displayed in different colors to make the spreadsheet simple to create and infer. You may experience data loss when you try to modify the data or change the color or size of the data. Though the information may exist, the data may show an error due to the following reasons:  

• White-colored text will not show in a white-colored cell
• Large font-sized data may not appear in small-sized cell
• Calculations may show (#VALUE) error after cell-formatting

Solution – Check and Clear Formatting

Make sure to use dark-colored text on a white-colored cell. Also, resize the cell to fit the text size. Check if numbers in a cell are entered as text. If so, you need to apply a number format to the text-formatted numbers. Read more about it, from here .

What Else You Can Do to Resolve the ‘Excel Data Disappeared’ Issue?

If you can’t recover the missing Excel file data, try to repair or extract the data from the file using the built-in Excel repair tool. Follow the below steps to use the tool:

• Open MS Excel, click File > Open > Computer > Browse.
• On the ‘Open’ window, select the file you want to repair and then click on the Open dropdown.
• Select Open and Repair.

Use the ‘Repair’ option to repair the file and recover as much data as you can from the repaired file. If this doesn’t work, use the ‘Extract’ option to recover the data.

If you fail to retrieve the disappeared data from that file using the above-listed steps, opt for an Excel repair tool , like Stellar Repair for Excel. This software has a proven track record of repairing corrupt or damaged Excel files and recover all the data.

The software helps:

• Fix all corruption errors. It helps in getting back the data which has disappeared.
• Repair a single as well as multiple Excel files.
• Recover all components of XLS/XLSX files – tables, chart sheet, cell comment, image and more.
• Preserve the worksheet properties and cell formatting.
• Support the latest Excel 2019 and earlier versions.

The Excel repair software repairs the Excel file in these simple steps:

• Launch and open the software.
• Select the corrupt Excel file by using the ‘Browse’ option. If the file location is not available, then find the Excel file using the ‘Search’ option.

• Click ‘Repair’ to scan the corrupt file.

• Once the repair process is complete, verify the components of Excel file and check if the available preview shows complete data that disappeared from Excel.

• Save file at default location or preferred location.

The Excel file with all the restored data will be saved at the selected location.

Conclusion

It is better to repair the affected Excel file than suffer the loss when data or text disappears in Excel. A professional software ensures that users get back all the data in the form of a new Excel file. Stellar Repair for Excel software repairs the corrupt file without modifying the original content and file format. The software’s easy-to-use user interface lets you perform the functions without formal software training and technical expertise.

How to Repair Multiple Excel Files by Using Stellar

With Stellar Repair for Excel, it is quite easy and simple to repair multiple MS Excel (XLS and XLSX) files that are damaged. This is because the software has a self-explanatory interface and hence is a Do-it-yourself software. Nonetheless, when using this software to repair multiple Excel files, you would have to add all of the files into the software by following a few pre-defined steps. Follow the steps mentioned below:

• Launch Stellar Repair for Excel software.
• Under Home menu, click Select file

• Click Browse and select corrupt Excel files. Select the checkbox to repair multiple files.

• Click Repair
• The software provides the preview facility. You can check the it on left pane.

• Save the repired filr ether Default location or Select New Folder radio button.

Stellar Repair for Excel Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files. This Excel recovery software restores everything from corrupt file to a new blank Excel file.

Learn More

How Can I Recover Corrupted Excel File 2016?

Error Messages Indicating Corruption in Excel File

• When an Excel 2016 file turns corrupt, you’ll receive an error message that reads: “The file is corrupt and cannot be opened .”

• But sometimes, you encounter the “Excel cannot open this file” error message due to corruption in the file.

Why does Excel File turn Corrupt?

Following are some common reasons that can turn an Excel file corrupt:

• Large size of the Excel file
• The file is virus infected
• Hard drive on which Excel file is stored has developed bad sectors
• Abrupt system shutdown while working on a worksheet

Workarounds to Recover Data from Corrupt Excel

The workarounds to recover corrupted Excel file 2016 data will vary depending on whether you can open the file or not.

How to Recover Corrupted Excel File 2016 Data When You Can Open the File?

If the corrupt Excel file is open, try any of the following workarounds to retrieve the data:

Workaround 1 – Use the Recover Unsaved Workbooks Option

If your Excel file gets corrupt while you are working on it and you haven’t saved the changes, you can try retrieving the file’s data by following these steps:

• Open your Excel 2016 application and click on the Open Other Workbooks option.

• Click the Recover Unsaved Workbooks button at the bottom of the ‘Recent Workbooks’ section.

• A window with list of unsaved Excel files will open. Click the corrupt file you want to open.

This will reopen your last saved version of the Excel workbook. If this method doesn’t work, proceed with the next workaround.

Workaround 2 – Revert to Last Saved Version of your Excel File

If your Excel file gets corrupt in the middle of making any changes, you can recover the file’s data if the changes haven’t been saved. For this, you need to revert to the last saved version of your Excel file. Doing so will discard any changes that may have caused the file to turn corrupt. Here’s how to do it:

• In your Excel 2016 file, click File from the main menu.
• Click Open. From the list of workbooks under Recent workbooks, double-click the corrupt workbook that is already open in Excel.
• Click Yes when prompted to reopen the workbook.

Excel will revert the corrupt file to its last saved version. If it fails, skip to the next workaround.

Workaround 3 – Save the Corrupted Excel File in Symbolic Link (SYLK) Format

Saving an Excel file in SYLK format might help you filter out corrupted elements from the file. Here are the steps to do so:

• From your Excel File menu, choose Save As.
• In ‘Save As’ window that pops-up, from the Save as type dropdown list, choose the SYLK (Symbolic Link) option, and then click Save.

Note: Only the active sheet will be saved in workbook on choosing the SYLK format.

• Click OK when prompted that “The selected file type does not support workbooks that contain multiple sheets”. This will only save the active sheet.

• Click Yes when the warning message appears - “Some features in your workbook might be lost if you save it as SYLK (Symbolic Link)”.

• Click File > Open.
• Browse the corrupt workbook saved with SYLK format (.slk) and open it.
• After opening the file, select File > Save As.
• In ‘Save as type’ dialog box, select Excel workbook.
• Rename the workbook and hit the Save button.

After performing these steps, a copy of your original workbook will be saved at the specified location.

How to Recover Corrupted Excel File 2016 Data When You Cannot Open the File?

If you can’t access the Excel file, apply one of these workarounds to salvage the file’s data.

Workaround 1 – Open and Repair the Excel File

Excel automatically initiates ‘File Recovery’ mode on opening a corrupt file. After starting the auto-recovery mode, it attempts to reopen and repair the corrupt Excel file at the same time. If the auto-recovery mode does not start automatically, you can try to fix corrupted Excel file 2016 manually by using ‘Open and Repair’. Follow these steps:

• Open a blank file, click the File tab and select Open.
• Browse the location where the corrupt 2016 Excel file is stored.
• When an ‘Open’ dialog box appears, select the file you want to repair.
• Once the file is selected, click the arrow next to the Open button, and then click the Open and Repair button.
• Do any of these actions:
• Click Repair to fix corrupted file and recover data from it.
• Click Extract Data if you cannot repair the file or only need to extract values and formulas.

If performing these actions doesn’t help you retrieve the data, proceed with the next workaround.

Workaround 2 – Disable the Protected View Settings

Follow these steps to disable the protected view settings in an Excel file:

• Open a blank 2016 workbook.

• Click the File tab and then select Options.

• When an Excel Options window opens, click Trust Center > Trust Center Settings.

• In the window that pops-up, choose Protected View from the left side navigation. Under ‘Protected View’, uncheck all the checkboxes, and then hit OK.

Now, try opening your corrupt Excel 2016 file. If it won’t open, try the next workaround.

Workaround 3 – Link to the Corrupt Excel File using External References

If you only need to extract Excel file data without formulas or calculated values, use external references to link to your corrupt Excel 2016 file. Here’s how you can do it:

• From your Excel file, click File > Open.
• From the window that opens, click Computer and then click Browse and copy the name of your corrupt Excel 2016 file. Click the Cancel button.

• Go back to your Excel file, click File > New > Blank workbook.

• In the new Excel workbook, type “=CorruptExcelFile Name!A1” in cell A1 to reference cell A1 of the corrupted file. Replace the ‘CorruptExcelFile Name’ with the name of the corrupt file that you have copied above. Hit ENTER.
• If ‘Update Values’ dialog box appears, select the corrupt 2016 Excel file, and then click OK.
• If ‘Select Sheet’ dialog box pops-up, select a corrupt sheet, and press the OK button.
• Select and drag cell A1 till the columns required to store the data of your corrupted Excel file.
• Next, copy row A and drag it down to the rows needed to save the file’s data.
• Select and copy the file’s data.
• From the Edit menu, choose the Paste Special option and then select Values. Click OK to paste values and remove the reference links to the corrupt file.

Check the new Excel file for recoverable data. If this didn’t work, consider using an Excel file repair tool to retrieve data.

Alternative Solution to Recover Excel File Data

Applying the above workarounds may take considerable time to recover corrupted Excel file 2016. Also, they may fail to extract data from a severely corrupted file. Using Stellar Repair for Excel software can help you overcome these limitations. The software helps repair severely corrupted XLS/XLSX file and retrieve all the file data in a few simple steps.

Key benefits of using Stellar Repair for Excel are as follows:

• Recovers tables, pivot tables, images, charts, chartsheets, hidden sheets, etc.
• Maintains original spreadsheet properties and cell formatting
• Batch repair multiple Excel XLS/XLSX files in a single go
• Supports MS Excel 2019, 2016, 2013, and previous versions

Check out this video to know how the Excel file repair tool from Stellar® works:

Conclusion

Errors such as ‘the file is corrupt and cannot be opened’, ‘Excel cannot open this file’, etc. indicate corruption in an Excel file. Large-sized workbook, virus infection, bad sectors on hard disk drive, etc. are some reasons that may result in Excel file corruption. The workarounds discussed in this article can help you recover corrupted Excel file 2016 data. However, manual methods can be time-consuming and might fail to extract data from severely corrupted workbook. A better alternative is to use Stellar Repair for Excel software that is purpose-built to repair and recover data from damaged or corrupted Excel file.

Fixed “Cannot Insert Object” Error in Excel | Step-by-Step Guide

Summary: The error “cannot insert object” in MS Excel can prevent you from modifying objects in the worksheet. This blog will discuss the primary reasons behind this error and the possible solutions to fix it. You will also learn about a professional Excel repair software that can help fix the error if it has occurred due to corruption in Excel file.

Many users have reported encountering the “cannot insert object” error while adding/embedding objects into the Excel file. It usually occurs when using Object Linking and Embedding (OLE) to add content (PDF, Microsoft documents) from external applications to worksheet. The error can also occur when using ActiveX control in Excel. Below, we’ll explain why you cannot insert object into Excel sheet and how to troubleshoot the issue.

Why the “Cannot Insert Object” Error Occurs?

• Macro Settings can prevent the insertion of objects into a workbook.
• The Excel file in which you are trying to add an element is corrupted.
• The object (you are inserting into the workbook) is damaged.
• Object size limitations.
• System’s insufficient memory might prevent new objects’ addition.
• Incompatible Excel file format.
• Add-ins controls are disabled.
• Incompatible or faulty Add-ins.
• Issue with Security Settings.

Methods to Fix the “Cannot Insert Object” Error in Excel

You may encounter the “Cannot insert object” error when trying to add an element stored on a network. It can occur due to issues with the file link, such as incorrect file location. In such a case, you can check the link by selecting the link to file option from the Insert tab.

Sometimes, the error can occur if the file in which you are trying to insert the object is locked and password-protected. In this case, you can unprotect the Excel file . If the issue still persists, then you can follow the below methods.

Method 1: Check and Change Restricted Security Settings

Excel provides security settings to protect your workbook. Sometimes, these settings can prevent inserting objects in the file. You can change the security settings to allow Excel to insert objects. To do so, follow these steps:

• Open your Excel application.
• Locate the File and then click Options.
• In Excel Options, click Trust Center.

• Click Trust Center Settings.
• In the Trust Center Settings window, select Protected View from the left pane.

• Under Protected View, unselect the below three options:
• Enable Protected View for files originating from the internet.
• Enable Protected View for files located in potentially unsafe locations.
• Enable Protected View for Outlook attachments.

• Click OK.
• Once you’re done with this, click on Macro Settings in the Trust Center window.
• Under Macro Settings, make sure “Disable all macros without notification” is not selected. If it is selected, then unselect it. After that, click OK.

• Restart Excel to apply the changes.

Method 2: Uninstall Microsoft Office Updates

You can also encounter the “Cannot insert object” error in Excel after installing MS Office updates. It might be due to the issues with the installed updates. To fix this, you can uninstall the recently installed Office updates. To uninstall the Office updates, follow these steps:

• Go to the system’s Control Panel.
• Click Programs and then click Program and Features.
• Search for “View Installed Updates” and click on the desired Office updates.
• Right-click on it and then click Uninstall.
• Follow the uninstallation steps on the screen.
• Once the process is complete, restart the system.

Method 3: Check Memory Usage

The “Cannot insert object” issue can also occur if your system is low on memory. You can check and close unnecessary processes and applications running in the background to free up memory. To do so, follow these steps:

• Press CTRL + ALT + DEL on the keyboard and click Task Manager.
• Click on the Processes tab and search for any unnecessary processes.
• Right-click on the process and then select End Task.
• Restart Excel to see if the issue is fixed.

Method 4: Check Excel File Size

If your Excel file size exceeds the prescribed limit, it can also lead to the “Cannot insert Excel object” error. So, check the Excel file size. You can reduce the file size by removing unnecessary objects, such as formulas or images.

Method 5: Check and Change Excel ActiveX Settings

You can get the “Excel cannot insert object” error if your Excel file contains macros, controls, and other interactive buttons. It usually occurs if the ActiveX Controls option is disabled. You can check and change the ActiveX Settings to fix the issue. Here are the steps:

• Open your Excel application.
• Navigate to File and then click Options.
• In Excel Options, click the Trust Center tab.
• In the Trust Center Settings, click ActiveX Settings.
• Under ActiveX Settings, make sure the “Enable all controls without restrictions and without prompting” option is selected.

• If the option is not selected, then select it and click OK.
• Restart the Excel and check if the error is fixed or not.

Method 6: Repair the Excel Workbook

The “Cannot insert object” error can occur if the object you are trying to insert is corrupted or the file in which you are inserting the object is damaged. If the issue has occurred due to a corrupted Excel file, then you can repair the file using the Open and Repair utility in MS Excel. To use this Microsoft-inbuilt utility, follow these steps:

• In the Excel application, go to the File tab and then click Open.
• Click Browse to choose the affected file.
• The Open dialog box is displayed. Click on the corrupted file.
• Click on the arrow next to the Open button and then click Open and Repair.
• Click on Repair.

• After repair, a message will appear (as shown in the below figure).

• Click Close.

If the Open and Repair utility fails to fix the issue, then try a professional Excel Repair software, like Stellar Repair for Excel. It is designed to repair severely corrupted Excel files. It can restore all the Excel file objects, such as tables, charts, formulas, etc. It helps fix all types of corruption related errors. The software is compatible with all versions of Excel.

Conclusion

You might encounter the “Cannot insert object” error when embedding or inserting objects in Excel. In this post, we have discussed the possible solutions to fix this error. We have also mentioned an Excel repair software that can help to easily repair the corrupted Excel file and recover all the data. You can download the Stellar Repair for Excel’s free demo version to preview the recoverable objects of the corrupted Excel file.

How Do I Repair and Restore Excel File?

When an Excel file turns corrupt, the file might become inaccessible or you might receive errors. You may encounter errors, such as ‘the file is corrupt and cannot be opened,’ ‘Excel found unreadable content in “filename>”,’ ‘Excel cannot open “filename” because the file format or extension is not valid,’ etc.

Common Reasons for Excel File Corruption

There are several reasons that can turn the file corrupt. The most common reason is a damaged hard drive. Other factors that can cause corruption in an Excel file are as follows:

• System crash or abrupt shutdown of the system while the file is still open
• Viruses infecting the file with malicious code
• Bug in the operating system
• Bad sectors on the drive where the file is stored
• Large spreadsheets with formulas and other components

Whatever be the reason, if your business is dependent on an Excel file, corruption in the file could hamper your business continuity. Also, you may lose crucial data. In such a situation, you could try to repair the file.

Before We Begin

It is important to identify the root cause behind Excel file corruption. If the problem has occurred due to a faulty hard disk drive, contact your hardware vendor to get it fixed. Also, move the file to another local drive and check if it opens. If nothing works, proceed with the methods discussed below to repair and restore the file.

Methods to Repair and Restore Excel File

Try the following methods to fix corruption in an Excel file and restore it.

Method 1 – Use the Built-in ‘Open and Repair’ Tool

You can use the Excel built-in Open and Repair utility to repair the corrupt file. Follow these steps:

• Open your Excel application and click on Blank workbook.

• On the blank workbook screen, click on the File tab.

• Click Open > Computer > Browse.

• Select the file you want to repair and then click on Open and Repair from the Open dropdown box.

• Click Repair to fix corruption in the Excel file and recover maximum data.

• If you get the following error message, click Yes to open the file.

• If clicking Yes opens the file with garbage entries (see the image below), perform Step 1 – 5 and click Extract Data. This will only help you recover data without formulas and values.

Note: You may also try to recover the data from a corrupted workbook by using the methods suggested by Microsoft .

A better way to repair and restore an Excel file with complete data is to use a specialized Excel file repair tool .

Method 2 – Use Excel File Repair Tool

Stellar Repair for Excel is a powerful tool designed to help users fix corrupted .xls or .xlsx files without any technical assistance. Also, the tool recovers all the components from a corrupted workbook, including tables, pivot tables, cell values, formulas, charts, images, etc. You can preview the repaired file and its contents by downloading the free demo version from the link below. It is a useful feature that allows the user to validate the data before saving it.

[

](https://tools.techidaily.com/stellardata-recovery/repaire-for-excel/ “Free Download For Windows”)

Here’s the step-by-step instructions to repair a corrupt Excel file using the software:

• Run the software. The software main interface opens with an instruction to add some add-ins if you’ve engineering formulas in the file you want to repair.

• Click OK to proceed.

• Select the file you wish to repair by using the Browse option.

Note: If you’re not aware of the file location, choose the ‘Search’ option to locate the file.

• A screen showing progress of the Excel file repair process is displayed.

• Preview of the repaired Excel file and its recoverable data is displayed.

• After verifying the data, click on the Save File button on the File menu to save the repaired file.

• Select the location where you wish to save the repaired file on the Save File window and then click OK.

A confirmation message will pop-up after completion of the repair process. You can now try to open the file in your Excel program.

End Note

Even if you’re taking preventive measures, you might still experience corruption in an Excel file. So, it’s crucial to take regular backups of your workbooks. For this, ensure that the ‘Always create backup’ option is enabled in Excel. You can find it in General Options by clicking on the Tools button in the Save As dialog box. Enabling it will ensure that the Excel backup file is updated with the changes made in a spreadsheet.

Additionally, ensure that the Excel ‘AutoRecover’ feature is set to save a version of your Excel file after every 10 minutes. You can increase or shorten the interval as per your requirement.

How to Repair Excel Document on a Flash Drive

Summary: Microsoft Excel files are stored on flash drives if they need to be transferred between systems or if they need to be backed up. But sometimes unforeseen issues can corrupt the Excel sheets stored on flash drives. When that happens, it can be an arduous task to repair Excel documents on a flash drive. Through this post let us try to understand the reasons why Excel sheets stored on flash drives can get corrupted and how users can resolve them easily.

In this digital age, we all work with computers, files, and documents. Flash drives or USBs are common ways of storing data in an external place. Be it for a meeting or for a party playlist, these devices come handy when one wants to transfer data or access the files stored elsewhere.

You may need to access your data from another location. That’s when a USB flash drive might come in handy. And, that’s exactly why Excel sheets too end up on flash drives; either that or for backup purposes. However, there are many instances where an Excel file stored in a USB gets corrupted when one tries to access the file. The error message you get while trying to open the Excel file would be a great clue for figuring out the exact reason behind corruption.

This blog will provide insights into what are the reasons for the corruption of a USB and how the users can repair Excel on flash drive that has been corrupted.

Reasons for USB inaccessibility

Sometimes flash drives or USBs can become unresponsive due to numerous reasons. There are two types of corruption – logical and physical. Physical corruptions occur due to broken stems and connectors, broken circuits, NAND gate, not recognised, RAW, need to format, not accessible, and dead drives (no power supply).

One of the main reasons behind such an error could be that the USB drive has been infected by some virus. This can affect any file – not only the ones which are there in the USB drive but also the ones which are there in the PC/Laptop where you connect the USB drive. It is recommended that you scan the USB drive with reliable antivirus software to detect viruses.

There can be various other reasons that may make your USB corrupt or unresponsive. But there are very slim chances that you will be able to recover a flash drive that has physical damage. However, you can try to run the check disk on the USB drive to fix the drive. We will be discussing this as you read on.

Recovery Methods for Corrupted Flash Drives

There are 3 tried and tested recovery methods. Try them and see which one works out for you.

1. Restoring Excel Files from Windows backup

To bring back your old Excel files, fixing up the corrupt file is your best option. Importantly note that this method would work only if your system’s Windows backup option has been enabled.

Step-by-step process for restoring your older Excel files:

• Connect your USB drive
• Go to “My Computer”->USB Drive->Check if the file exists
• Right click on the excel file and click on the restore previous versions

• You will now see a list of older versions which were created
• Select one the backups and click on “restore”

2. Using Command Line to Recover Excel Files

In case you are looking to repair Excel on flash drive, you can also resolve it by using the command line. Just follow the below steps to see if you can recover the excel files.

• Connect your USB Flash drive
• Open “Run” (press Windows+R) and then open “cmd”

• Type “attrib -h -r -s /s /d (USB Drive Letter):\*.*” where the (USB Drive Letter) is the drive letter you can find using “My Computer”
• Once this has been completed, Windows will start repairing your files
• After the process gets over, try accessing the excel file to see if the data has been recovered

3. Running a “Check Disk” on flash drives

Follow the below steps while the USB flash drive has been plugged into your computer:

• Open “Run” and then open “cmd”
• Type in “chkdsk /X /f (USB Drive Letter)” where the “(USB Drive Letter)” is the letter of the corrupted USB Drive. You can get this letter easily from the “My Computer”.

It will now check your disk to and correct any corrupted records.

What if none of these methods works?

In case none of the above methods works to repair Excel document on a flash drive, then you would need a professional Excel repair software such as Stellar Repair for Excel to restore your files. Such software not only help repair corrupted Excel files on flash drives but also help in recovering the data stored within them in their original format.

Stellar Repair for Excel resolves corruption problems in Excel files and recovers all formulas, charts, cell formatting, and more from them. It can repair multiple Excel files in one go. Equipped with a fully interactive GUI, working with this product is extremely easy.

To sum it up

Although flash drives are quite popularly used, they are not the most reliable of storage devices. These drives can fail anytime without warning. Thus, always back up your data on other more robust devices instead of flash drives. We hope that with the above tried and tested methods you will easily be able to repair Excel document on flash drive if need be. For any queries that you have, feel free to leave a comment below!

Also read: