how to repair excel file 2010

Full Answer

How do I reinstall Excel?

• Browse to ?:\Pfx Engagement\WM\Utilities on your computer. ...
• Right-click epace.xla and select Copy .
• Go to your current version of Office##\Library.
• The Office library location varies based on your version of Office installed. ...
• Delete epace.xla (if listed).
• Right-click in the window and select Paste.
• Navigate to %AppData%\Roaming\Microsoft\Excel.

More items...

How do you repair Excel?

Windows 10

• Click on the Windows "start" icon (bottom-left corner of your screen).
• Click on "Settings". The "Windows Settings" window should appear.
• Click on "Apps". ...
• Select "Microsoft Office" (or "Microsoft Excel" if you do not have the full Office installation).
• Click "Modify".
• Choose from "Quick Repair" or "Online Repair".

How to reinstall Microsoft Excel?

• Click Start (or Start > Run in Windows XP).
• Type appwiz.cpl, and then press Enter. ...
• Click Microsoft Office Starter 2010, and then click Uninstall (or Remove in Windows XP).
• Click Yes and follow the instructions to uninstall Office Starter 2010.
• To reinstall Office Starter 2010, click Start > All Programs > Microsoft Office 2010.
• Click Use.

More items...

How do I repair a corrupt Excel file?

Repair a corrupted workbook manually

• On the File tab, click Open.
• In Excel 2013 or Excel 2016, click on the location where the spreadsheet is located, and click Browse.
• In the Open dialog box, select the corrupted workbook that you want to open.
• Click the arrow next to the Open button, and then click Open and Repair.

More items...

How do I repair a corrupt Excel File?

Repair a corrupted workbookClick File > Open.Click the location and folder that contains the corrupted workbook.In the Open dialog box, select the corrupted workbook.Click the arrow next to the Open button, and then click Open and Repair.To recover as much of the workbook data as possible, pick Repair.

How do I open and repair an Excel File?

On the File tab, click Open. In Excel 2013 or Excel 2016, click on the location where the spreadsheet is located, and click Browse. In the Open dialog box, select the corrupted workbook that you want to open. Click the arrow next to the Open button, and then click Open and Repair.

How do I restore an Excel File 2010?

Click the "Uninstall a program" link under Programs. Scroll down and highlight "Microsoft Office." Click the "Change" button and wait for a new window to open. Click to select the "Repair" option and click "Continue" to authorize your computer to repair Microsoft Excel to its default settings.

How do I fix Excel 2010 not responding?

Excel not responding, hangs, freezes or stops workingStart Excel in safe mode. ... Install the latest updates. ... Check to make sure Excel is not in use by another process. ... Investigate possible issues with add-ins. ... Investigate Excel file details and contents. ... Check whether your file is being generated by a third party.More items...

Why Excel file is corrupted?

Excel files can get corrupted if they were not saved properly, this could be because you did not shut down the program properly or if it shut down abruptly because of a power failure, hardware failure, or because of a virus or malware attack.

How do you check if Excel file is corrupted?

The following are common signs that your Excel file is corrupt. When you try to open your file and it fails to respond, there is a chance it is corrupt. Sometimes you may get the error message 'Unable to read file'. Another error you are likely to come across is 'Excel Cannot Open the File '(Filename)'.

How do I get my Excel spreadsheet back to normal?

Switch to full or normal screen view in ExcelTo switch to full screen view, on the View tab, in the Workbook Views group, click Full Screen.To return to normal screen view, right-click anywhere in the worksheet, and then click Close Full Screen.

Where are auto recovery files saved Excel?

To do this, click “File” on the ribbon, go to the “Info” section, and choose “Manage Workbook”. Choose “Recover Unsaved Workbooks” to display and recover unsaved Excel files. Excel saves unsaved files to the folder C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles. You can also access the files from this folder.

Where is AutoRecover in Excel?

Step 1: Go to the File tab and click on the “Options” list. Step 2: You can look for the “Save” option in the left-hand side list under Options. Click on the “Save” and find the “AutoRecover” option under Save Workbooks. Step 3: In Microsoft Excel, your File automatically gets saved after every 10 minutes.

What causes Excel not responding?

Excel often freezes upon opening or it suddenly stops responding when you open a file. This issue is frequently caused by previously installed add-ins or macros and not by Excel itself. Antivirus software and Windows updates are other common causes of this error.

Why my Excel file is not opening?

On the File menu, select Options, and then select Add-Ins. In the Manage list at the bottom of the screen, select COM Add-Ins item, and then select Go. Clear one of the add-ins in the list, then select OK. Restart Excel by double-clicking the icon or file name for the workbook that you are trying to open.

Why Microsoft Excel is not responding?

Solution 1: Open Excel in Safe Mode It is a common DIY way to fix 'Excel is not responding' problem. In Safe Mode, Excel starts with only essential services, bypasses certain functionalities and doesn't load the add-ins, which might be the reason behind the error in MS Excel .

How to repair Excel 2010?

The detailed steps to open and repair Excel 2010 are as follows: Open Microsoft Excel 2010 and click File from the main menu. Next, click Open. Browse the corrupt Excel 2010 file on your computer and select it in the Open dialog. Click the arrow next to the Open button and choose Open and Repair.

How to access a corrupted Excel file?

Browse the HTML file that you have saved. Click File from the main menu, and select Save As in the list. Type-in a different name, choose Microsoft Excel Workbook in the ‘Save as’ type drop-down menu, and then click the Save button. With this, you would be able to access the data in the corrupt Excel file.

How to save Excel 2007 file?

To save the repaired file, click the Save File option on File menu. In ‘Save File’ dialog box, choose to recover Excel 2007 & 2010 data to either the Default or New location. Click OK. The repaired Excel file gets saved at the specified location.

Why is my Excel file corrupt?

There are several reasons that can cause Microsoft Excel workbooks to turn corrupt, such as virus attack, bad sectors on a drive on which Excel file is saved, system shutdown without properly closing the Excel application , etc. Corruption in an Excel workbook can result in data loss or render the workbook inaccessible.

How to save an Excel file as HTML?

The steps to save an Excel file in HTML format are as follows: Open Microsoft Excel 2010, click Save As, and then choose Web Page in the ‘Save as’ type drop-down list. Select the "Enable Entire Workbook” option, and then click the Save button. Close the Excel file and reopen your Microsoft Excel application.

How to recover data from Excel workbook?

Recover data when you can't open the workbook in Excel. Set the calculation option in Excel to manual Try changing the calculation setting from automatic to manual. Because the workbook won't be recalculated, it may open. Click File > New. Under New, click Blank workbook.

What to do if repair isn't able to recover?

If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook. If neither automatic nor manual repair works, there are some recovery methods that might help salvage your data. You can also take some preventive measures to avoid losing your work by automatically saving a backup copy ...

How to recover a workbook that was deleted accidentally?

A recovery file of your workbook also helps ensure you'll have access to your data if your workbook is deleted accidentally or if it becomes corrupted. Click File > Options. In the Save category, under Save workbooks, check the Save AutoRecover information every box, and then enter a number of minutes.

How to avoid losing work?

You can also take some preventive measures to avoid losing your work by automatically saving a backup copy of your workbook or creating a recovery file from time to time. Recover data from a corrupted workbook. Automatically save a backup copy of a workbook. Automatically create a recovery file at set intervals.

Can you revert a workbook to the last saved version?

Revert the workbook to the last saved version If a workbook becomes corrupted while you work but before you save your changes , you can revert your workbook to the last saved version:

How to recover an Excel file?

Browse to select the Excel file you need to Recover. Select the appropriate file from its proper location and click Open. Click Repair. The process begins. On completion, you will receive a report, Click on Save. Select Path or Destination where you wish to save by clicking Select Path and Click Save.

Why is Excel important?

Excel Spreadsheets are very important means of storing important data and they provide a variety of functions, important for managing recorded data. When it comes to taking care of large data, MS Excel is a trusted option. Whether home or office, small scale or large-scale industries, Excel has proven itself really important in terms of usage.

What happens when you increase the size of an Excel file?

Hence, when the increase in Excel file size, chances of corruption in the Excel file increases. Virus attack and hacking causes a significant amount of damage to your Excel files. The data might disappear and you might lose them. Since much of your information stored in these files can be misused by the hackers.

What are the natural disasters that can cause severe damage to Excel?

Natural calamities such as Tsunami, Earthquake, Flood, etc. are unavoidable and has the power to cause severe damage to Excel Files either directly or indirectly through harm inflicted upon your System and so on. Like all errors, this too; creates a major hindrance to work by hindering proper working of Excel 2010.

Can you lose data from mishandling Excel?

Likewise, you distractedly close the running Excel document without having saved it. As a result, you lose the data.

Why is my Excel file corrupted?

Ideally, you should look for the following common causes for corrupting an Excel file so that you can avoid them in the future. Unexpected power shutdown when the file was still in use. A virus or malware attack can also corrupt your Excel file and make it harder for the system to read it.

How to open corrupted Excel file in 2016?

Launch MS Excel 2016 on your system and click on the Open button from the File menu to load a file. 2. Choose to browse the file instead of creating a new file. 3. As a browser window would be opened, go to the existing location where the corrupt file is stored. 4.

Can Stellar Phoenix fix Excel?

It doesn't matter what could have caused your Excel file to get corrupt, you can easily fix it using Stellar Phoenix Excel Repair. A user-friendly and 100% reliable tool, it can fix Excel files in different scenarios.

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:

Methods to Repair and Restore Excel File

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

What to do if Word isn't working?

If an Office application such as Word or Excel isn’t working correctly, sometimes restarting it will fix the problem. If that doesn’t work, you can try repairing it. When you’re done, you might need to restart your computer.

How to uninstall a program from Windows 10?

In Change your installation, select Repair and then click Continue. Follow the instructions on the screen to complete the repair. Right-click the Start button (lower-left corner), and select Control Panel from the pop-up menu. From Category view, under Programs, select Uninstall a program.