Excel issues. Repairing a corrupted workbook. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013. When you open a workbook that has been corrupted, Excel automatically starts File Recovery mode and attempts to reopen and simultaneously repair the workbook. Excel cannot always start File Recovery mode automatically.

This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel workbook. These types of problems may occur for one or more of the reasons listed below.

When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook: Click File > Open.

[FIXED] Excel gives warning when you open files from a network location if the file extension is correct [FIXED] Error "Invalid password" when opening a VBA project using the correct password [WORKAROUND] Excel may stop or close when using new IME in Windows 11

Open the following registry key: HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command. In the right pane, click (Default). On the Edit menu, click Modify. Remove the %1 from the end of the Value data string so that the data string reads as follows: "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (including the quotation marks)

Lists the file formats that are supported in Excel. The topic also includes a list of unsupported file formats and some suggested workarounds.

Do your work. With Excel, you can enter data, and create tables, charts, and formulas. Click the tabs at the top to find the features you want. To collapse the ribbon and make more space, double-click a tab. Enter data. To manually enter data: Select an empty cell, such as A1, and then type text or a number.

Share your workbook. Select Share on the ribbon. Or, select File > Share. Note: If your file is not already saved to OneDrive, you'll be prompted to upload your file to OneDrive to share it. Select who you want to share with from the drop-down, or enter a name or email address. Add a message (optional) and select Send.

You can now open and save CSV files that use UTF-8 character encoding. Go to File > Save As > Browse. Then click the Save as type menu, and you'll find the new option for CSV UTF-8 (Comma delimited). CSV UTF-8 is a commonly used file format that supports more characters than Excel’s existing CSV option (ANSI). What does this mean?

Turn your data into insights. List of all Excel functions available. VLOOKUP function. IF function. Create a drop-down list. Combine text from two or more cells. Freeze panes to lock rows & columns. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable.