Ensuring Compatibility with Older Excel Versions

Written by Allen Wyatt (last updated April 23, 2022)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021


1

In Mary's company they often send Excel workbooks to vendors and contractors, all using differing versions of Excel. She wonders if there is a way to ensure that they don't inadvertently use a worksheet function that will not work on older versions of Excel that others may be using. Mary notes that in their office they don't have all the older versions of the program in order to test.

In the old days (not really that long ago), Microsoft would update Excel every couple of years and introduce a limited number of new features in each version. One might reasonably refer to these as the "good old days," because now it seems that Microsoft is introducing new features every couple of months. And some of those new features can be showstoppers, if used and shared with people using older versions of the software.

Fortunately, Excel includes a compatibility checker that can help you identify whether your workbook uses features that could cause heartburn for users of older versions. To use the checker, follow these steps:

  1. Save your workbook as you normally would.
  2. Display the File tab of the ribbon.
  3. At the left side of the screen, click Info. Excel displays information about the workbook and some tools.
  4. Click the Check for Issues button. Excel displays a drop-down list of things you can check.
  5. Click the Check Compatibility option. Excel displays the Compatibility Checker dialog box. (See Figure 1.)
  6. Figure 1. The Compatibility Checker dialog box.

At this point you can see what issues are flagged by Excel. You can filter which issues are displayed by using the Select Versions to Show drop-down list. You can also tell Excel to run the Compatibility Checker each time the workbook is saved by clicking the appropriate checkbox near the bottom of the dialog box. Also, if you click the Copy to New Sheet button, then Excel allows you to copy the compatibility information to a new worksheet so you can use it as a checklist to track down the compatibility issues.

If you have people who are using even older versions (pre-2007), the best approach is to simply do a Save As (press F12) and save in the .XLS format. During the process of saving, Excel will let you know what features will not be saved into the older file format.

You can find additional information by accessing either of these pages on Microsoft's support site:

https://go.tips.net/compat
https://go.tips.net/compat2

Of course, you may want to consider if the vendors and contractors really need access to the workbook in Excel format. If all they need to do is to see, for example, is an inventory level, a project status, or a price list, then consider generating a PDF file from your workbook. That PDF can be viewed by just about anyone without the need for you to be concerned about Excel version compatibility.

Finally, if you simply need to share raw data (values) with your contractors or vendors, then you might consider saving your worksheet in CSV format. Then the data can be loaded into whatever spreadsheet program they are using. It won't have any formatting, but it will allow you to share data rather easily.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9974) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Creating a Master Document Using Existing Subdocuments

If you decide to create a master document, it is easy to do by just adding one or more subdocuments to an existing ...

Discover More

Adding Borders to Cells

Excel makes it easy to add all sorts of lines around a cell or range of cells. How easy? This tip demonstrates how to add ...

Discover More

Using Very Large Font Sizes

You can format your text to use some very, very large font sizes. The results you see from formatting with large fonts ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More ExcelTips (ribbon)

Excel Self-Tests

Need to find out how good you are with Excel? Here are some places you can check out to quiz yourself.

Discover More

Weird Actions for Arrow Keys and Enter

If your arrow keys and the Enter key aren't working as you expect them to, the problem could have any number of causes. ...

Discover More

Dividing the Screen Unevenly between Two Workbooks

When working with multiple workbooks, you'll typically want to resize the workbook windows so you can see the data from ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 8 - 3?

2022-04-25 01:36:13

Philip

Any information on how to find this compatibility checker on a Mac ? The instructions above are Windows specific (there is now "backstage" on Mac versions), and I've been looking without success on the Mac version to find out how to do this ...

Thanks for any useful feedback ...


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.