Learn how to recover files that have been lost, deleted, or accidentally changed.

To open a file that was created in another file format, either in an earlier version of Excel or in another program, click File > Open. If you open an Excel 97-2003 workbook, it automatically opens in Compatibility Mode. To take advantage of the new features of Excel 2010, you can save the workbook to an Excel 2010 file format.

Use the Office offline installer to install Office 2016 or Office 2013 if you don't have an active Internet connection or you're having problems with slow speed or unreliable connections.

When versioning is enabled in your SharePoint list or library, you can store, track, and restore items in a list and files in a library whenever they change.

First, you'll need to download the troubleshooter. Download troubleshooter. If you see the File Download box when you start downloading, select Run or Open. The troubleshooter provides steps for you to follow. If a program isn't listed in the uninstall options, you'll be asked for that program's product code.

If you’re an administrator, you can use the Office Deployment Tool to manage your Office 2016 Click-to-Run deployment options, such as installations sources, product and language combinations, or deployment configuration options. Download Deployment Tool. Was this information helpful?

Microsoft Office uses the XML-based file formats, such as .docx, .xlsx, and .pptx. These formats and file name extensions apply to Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

For backward compatibility with earlier versions of Excel, such as Excel 97-2003, you can use one of two ways to exchange workbooks between the different versions.

Enable and configure versioning for a list or library. You can track and manage information over time with versioning in lists and libraries, as well as view and recover previous versions from the item's history. When enabled, new versions are added to an item's history after changes are saved.

To include structured references in your formula, click the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to enter a formula that automatically uses structured references to calculate the amount of a sales commission.