how to repair excel 2013

Full Answer

How do you repair Excel?

• Go to File > Open and navigate to the folder location that contains the corrupt Excel file • Choose the damaged Excel file and click the arrow icon next to the Open button, and then click on Open and Repair… • Click Repair to fix the corrupt Excel file

How do I repair and restore Excel file?

To repair a corrupted Excel for free, do the following:

1. Click "File" > "Open". Click the location and folder that contains the corrupted workbook.
2. In the Open window, select the corrupted Excel file.
3. Click the arrow next to the Open button, and then click "Open and Repair". Or you can click "Repair" to recover Excel data.

How do I reinstall Microsoft Excel?

• Enabling Microsoft® Office Add-ins
• Re-installing the Microsoft® Word and Excel® Ribbon Add-in Files
• Replacing the Microsoft® Word Add-ins
• Replacing the Microsoft® Excel® Add-ins

How to repair Microsoft Excel?

Windows 8 / 8.1

• Right-click on the Windows "start" icon (bottom-left corner of your screen) to open the "Start Context Menu". ...
• Select "Programs and Features". ...
• Select "Microsoft Office" (or "Microsoft Excel" if you do not have the full Office installation).
• Click "Change".
• Choose from "Quick Repair" or "Online Repair".

How do I repair Excel 2013 in Windows 10?

In the window How would you like to repair your Office Programs, select Online Repair > Repair to make sure everything gets fixed. (The faster Quick Repair option is also available, but it only detects and then replaces corrupted files.) In Change your installation, select Repair and then click Continue.

How do I run a repair in Excel?

Open Excel, and go to "Help" (at the top of the Excel window, next to "File", "Edit", "View", "Insert" etc.). Select "Detect and Repair..." (see screenshot). Make sure to select "Restore my shortcuts while repairing". Click "Start" to begin the Detect and Repair process.

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.

Why Excel 2013 is not working?

If Excel 2013 will not start in Safe mode, or all add-ins are disabled and Excel still does not start, there could be a conflict with another program. You may need to start Windows in Safe mode or different advanced troubleshooting modes so that you can find and fix the problem.

How do I fix Excel not responding without losing data?

16 Possible Ways to Fix 'Excel Not Responding Without Closing'...Wait till Excel Responds Again. ... Open Excel in Safe Mode. ... Update Microsoft Excel in Your PC. ... Close Processes That Are Using Excel. ... Check Issues with Excel Add-Ins. ... Investigate the File Contents If Excel Is Not Responding. ... Check If the Excel File Is Corrupt.More items...•

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 open a corrupted Excel file 2013?

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.

Why Excel file gets 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 fix the file is corrupted and Cannot be opened?

Part 1: 6 Fixes for "the file is corrupted and cannot be opened" ErrorFix 1: Change Component Services Settings. ... Fix 2: Uncheck Protected View Options. ... Fix 4: Repair MS Office Application. ... Fix 5: Use Open and Repair Feature. ... Fix 6: Change File Extension (Excel Only)

Why Excel suddenly stops working?

Cause 1 – Microsoft Office Excel Application is Outdated Excel may stop working, hang or freeze, if you have not installed MS Office updates.

Why is my 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 is not opening?

The most common reason for this problem: Excel won't open a file because the file is corrupted. This is especially common if Excel crashes while saving the file, or if a problematic macro prevents the file from being saved correctly.

Where is the open and repair button in Excel?

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 recover corrupted files?

The Open and Repair command might be able to recover your file.Click File > Open > Browse and then go to the location or folder where the document (Word), workbook (Excel), or presentation (PowerPoint) is stored. ... Click the file you want, and then click the arrow next to Open, and click Open and Repair.

Is it possible to restart Excel?

Click on file, Options. Go to the Advanced tab. Under the Display section, check the box for 'Disable hardware graphics acceleration'. Click ok and restart Excel.

How do I repair Excel in Office 365?

Click Start, and then click Control Panel. Double-click Programs and Features. Click MicrosoftOffice 365, and then click Change. Select Quick Repair, and then click Repair.

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.

What is a virus in Excel?

Virus: Computer viruses are programs maliciously designed to infect source or data files on a computer, often at a very large scale. A computer system contaminated with the virus can be a cause of Excel files getting corrupted.

Can Excel be restored from backup?

The file can be restored from the backup whereas backup must be maintained automatically. 2. Restore (from the Recovery file). This is an alternative to backup, a file comprising all the Excel data that you can fetch back even if data is deleted or damaged accidentally.

How to repair a corrupted Excel spreadsheet?

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.

How to recover data from an Excel workbook?

To recover data when the workbook is open in Excel, do one of the following: Revert the workbook to the last saved version If you are editing a work sheet and the workbook becomes corrupted before you save your changes, you can recover the original worksheet by reverting it to the last saved version.

How to set calculation option in Excel?

To set the calculation option in Excel to manual, do the following: Make sure that a new, blank workbook is open in Excel. If a new, blank workbook is not open, do the following: On the File tab, click New. Under Available Templates, click Blank workbook. On the File tab, click Options.

Why do you need to create a recovery file for Excel?

Configuring Excel to periodically create a recovery file of your workbook helps to ensure that you will have access to a good copy of the workbook, if the original is deleted accidentally or if it becomes corrupted.

Can Excel open a file that has been corrupted?

Excel cannot always start File Recovery mode automatically. If you cannot open a workbook because it has been corrupted , you can try to repair the workbook manually.

How to repair corrupted Excel file?

To do so, follow the steps below: Click on the File menu, and then select Open. In the Open dialog box, navigate to the folder location where the corrupt Excel file is saved. Select the corrupt file, and then click on arrow sign available next to Open button to select Open and Repair option. Figure 2 – Open and Repair Feature in Excel.

What to do if we found problem with some content in Excel?

If the above manual methods fail to fix the ‘we found problem with some content in excel error’, try using the Stellar Repair for Excel software to resolve this error . The software helps repair and recover corrupt Excel files in just a few clicks. It can be used on a Windows 10/ 8/ 7/ Vista/ XP/NT machine to repair corrupted workbook, and recover every single bit of data from all the versions of Excel workbook.

How to make Excel file accessible?

To make the file accessible, try setting the calculation option in Excel from automatic to manual. As a result, the workbook will not be recalculated and may open in Excel. For this, perform the following: Click File, and then click New. Under New, click the Blank workbook option.

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 fix Excel not opening in Windows 7?

If you are running Windows 7, click Start > type Excel /safe in Search programs and files, then click OK. If the issue is resolved, click File > Options > Add-ins. Select COM Add-ins, and click Go. Clear all the check boxes in the list, and click OK. Close and restart Excel.

How to run Excel safe?

If you are running Windows 10, choose Start > All apps > Windows System > Run > type Excel /safe in the Run box, then click OK. If you are running Windows 8, click Run in the Apps menu > type Excel /safe in the Run box, then click OK. If you are running Windows 7, click Start > type Excel /safe in Search programs and files, then click OK.

Why is Excel so slow?

Excel is printer-intensive, and it will run slower when Excel files are saved in Page Break Preview view. Testing a file by using different printers such as the Microsoft XPS Document Writer printer driver, or the VGA video driver will determine whether the problem is with a specific printer or video driver.

How to start Excel in safe mode?

You can open Excel in safe mode by pressing and holding Ctrl while you start the program, or by using the /safe switch (excel.exe /safe) when you start the program from the command line. When you run Excel in safe mode, it bypasses functionality and settings such as alternative startup location, changed toolbars, the xlstart folder, and Excel add-ins. However, COM add-ins are excluded.#N#If your issue is resolved after you run Excel in safe mode, see: How to troubleshoot startup problems in Excel.

Why is Excel so large?

Excel files can grow fairly large when you start adding lots of formatting and shapes. Make sure that your system has enough RAM to run the application. For system requirements of the Microsoft Office suites, go to the following Microsoft articles:

Can I disable Excel integration?

If your antivirus software includes integration with Excel you may experience performance issues. In this case, you can disable all Excel integration within the antivirus software. Or, you can disable any antivirus software add-ins that are installed in Excel.