Excel displays the Compatibility Checker dialog box. Excel displays a drop-down list of things you can check.

Excel displays information about the workbook and some tools.

At the left side of the screen, click Info.

Save your workbook as you normally would.

And some of those new features can be showstoppers, if used and shared with people using older versions of the software.įortunately, Excel includes a compatibility checker that can help you identify whether your workbook uses features that could cause heartburn for users of older versions. 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.

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. Mary notes that in their office they don't have all the older versions of the program in order to test. 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. In Mary's company they often send Excel workbooks to vendors and contractors, all using differing versions of Excel.

Excel 2013 to 2016 compatibility