How To Make Excel Files Compatible With Older Ms Office Versions 2016/365/2019

Excel for lingocard.vn 365Excel 2019Excel 2016Excel 2013Excel 2010Excel 2007Excel Starter 2010More…Less

You’ve upgraded to a new version of Excel, and realize you’ll be sharing workbooks with people who haven’t upgraded yet. Running the Compatibility Checker can help you identify features or information that might not be available in an earlier version, so you can resolve some of those issues before you share your workbook.

Đang xem: How to make excel files compatible with older ms office versions

Save a file to .xls format and review Compatibility Checker issues

Follow these steps:

Click File > Export > Change File Type.

Under Workbook File Types, double-click Excel 97-2003 Workbook (*.xls).

*

In the Save As popup window, choose a folder location for the workbook.

In the File name box, type a new file name (or use the one that’s already there).

Click Save.

If the Compatibility Checker appears, review any compatibility issues that were found.

*

The Find link takes you to that place in your worksheet, and the Help link takes you to information on the issue and possible solutions. 

Notes: 

In your new version of Excel, the workbook you just saved in .xls format opens in Compatibility Mode. Keep working in this mode when you plan to send this workbook back and forth to people who open it in the earlier version of Excel.

Run the Compatibility Checker for Excel 2007 and later

To verify that a workbook is compatible with Excel 2013, 2010, or 2007, run the Compatibility Checker manually the first time you save your workbook. Then set the Compatibility Checker to run automatically every time you save that workbook.

Xem thêm: Các Đề Văn Nghị Luận Văn Học Lớp 9 Đạt Điểm Tối Đa, 500 Bài Văn Mẫu Hay Nhất Lớp 9

Follow these steps:

Click File > Info > Check for Issues.

*

Choose Check Compatibility.

To check for compatibility automatically from now on, check the Check compatibility when saving this workbook box. 

Tip: You can also specify the versions of Excel that you want to include when you check for compatibility. All versions are checked by default, so just uncheck the versions you don”t want to include.

*

If any issues are found, the Find link takes you to that place in your worksheet, and the Help link takes you to information on the issue and possible solutions.

Use Access to combine data sources for Data Features that use multiple tables

Note: You can also use the VLOOKUP function in Excel to address this issue, but the process is somewhat complicated, and becomes more complicated as the number of data sources to combine increases.

Excel 2010 and earlier versions don”t lingocard.vn data features that analyze multiple tables, because those Excel versions don”t have a Data Model. If your workbook contains any such features, you may be able to prepare them for use in earlier versions by combining the feature”s data sources into a single table and then using that new table as the data source.

One way to do this is to use Access to combine the data sources and reproduce them as a query, which you can then import into your workbook. The process goes like this:

In Excel, open the Relationships dialog box by clicking Data > Data Tools > Relationships and note the relationships between the original data sources.

Once your data is in one table in Excel, choose that table as the data source for the data features that were using multiple tables, or recreate the data features and choose the new table as their data source.

Xem thêm: Bất Phương Trình Tích Thương

Need more help?

You can always ask an expert in the Excel Tech Community, get lingocard.vn in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Excel formatting and features that are not transferred to other file formats

Xem thêm bài viết thuộc chuyên mục: Excel