To co-author together, make sure everyone is using the Microsoft 365 subscription version of Excel or Excel for the web. Make sure the file is closed on all your devices. If the error still occurs, wait a few minutes for the server to release the lock on the file.

Learn how to remap buttons, adjust stick sensitivity, and update firmware for your Xbox Elite Wireless Controller Series 2.

As an alternative, you can import a text file by connecting to it with Power Query. Go to the Data tab > Get External Data > From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import, and the Text Import Wizard dialog will open.

To recover as much of the workbook data as possible, pick Repair. 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.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Templates can store styles, AutoText entries, AutoCorrect entries, macros, toolbars, custom menu settings, and shortcut keys. Loading a template makes it available as a global template that you can use while you work with documents based on any other template.

See how to work with ActiveX controls in your files, changing their settings, and how to enable or disable them by using the Message Bar and the Trust Center. You can also learn more about ActiveX controls and how they improve your files.

In Microsoft 365 and Office 2024, the settings for ActiveX controls have changed to be disabled by default. When ActiveX controls are disabled, you will not be able to create new ActiveX objects or interact with existing ones. This change applies to Word, Excel, PowerPoint, and Visio.

Excel can automatically generate a built-in data form for your range or table. The data form displays all column headers as labels in a single dialog box. Each label has an adjacent blank text box in which you can enter data for each column, up to a maximum of 32 columns.

Restore a previous version of an item or file in SharePoint. Enable and configure versioning for a list or library. Use Version History to view previous versions of files stored in OneDrive or SharePoint libraries.