Microsoft Office Tutorials and References
In Depth Information
Understanding Excel Versions
Version Released Comments
8 1997 This version, known as Excel 97, was the first version to support
conditional formatting and data validation. It also incorporated new menus
and toolbars. VBA programmers found quite a few enhancements,
including a completely new VBA editor, UserForms, class modules, and
9 1999 This version, known as Excel 2000, could use HTML as a native file
format and (for the first time) supported COM add-ins. It also featured a
self-repair capability, an enhanced Clipboard, and pivot charts. VBA
programmers could use modeless UserForms, and several new VBA
functions were introduced.
10 2001 Known as Excel 2002 (or Excel XP), this version is part of Office XP. It
has a long list of new features, but most of them are of little value to
the majority of users. Perhaps this version’s most significant feature is
its ability to recover your work when Excel crashes.
11 2003 Officially known as Microsoft Office Excel 2003, this version’s new
features are improved support for XML, a new list range feature, Smart
Tag enhancements, and corrected statistical functions.
12 2007 This version is officially known as Microsoft Office Excel 2007. This
version introduced many new features, including new file formats, a
revamped user interface, support for much larger worksheets, a handy
page layout view, document themes, new conditional formatting
options, much better-looking charts, a new table feature, a few new
worksheet functions, and much more.
14** 2010 I used this version when I wrote this topic. Microsoft Office Excel 2010
includes a fair number of new features, including Sparkline graphics, a
new Backstage View for document-related operations, new worksheet
functions, end-user Ribbon customization, PivotTable Slicers, an
Equation Editor, and even image-editing enhancements.
* Excel 6 doesn’t exist. Beginning with Excel 7, the version numbering was changed so that all Microsoft Office applications had the
same version number.
** Apparently, Microsoft is a bit superstitious. They skipped Office 13.
If you must share a workbook with someone using a version before Excel 2007, save the file as
an XLS file by choosing the Excel 97–2003 Workbook option in the Save As dialog box. Pay
attention to the results of the Compatibility Checker, which appears automatically whenever you
save your file in this older format. This useful dialog box, shown in Figure 1-1, identifies potential
problems when your workbook is used by someone who has an Excel version earlier than Excel