30
/
AIzaSyAYiBZKx7MnpbEhh9jyipgxe19OcubqV5w
April 1, 2024
603030
51085
2

1h 5min, jan 2, 2007 y - Version 12

Description:

Included in Microsoft Office 2007. This release was a major upgrade from the previous version. Similar to other updated Office products, Excel in 2007 used the new Ribbon menu system. This was different from what users were used to, and was met with mixed reactions. One study reported fairly good acceptance by users except highly experienced users and users of word processing applications with a classical WIMP interface, but was less convinced in terms of efficiency and organisation. However, an online survey reported that a majority of respondents had a negative opinion of the change, with advanced users being “somewhat more negative” than intermediate users, and users reporting a self-estimated reduction in productivity. The new features included in this version are:

New Ribbon menu System. This was a major upgrade.
SmartArt set of editable business diagrams.
Improved management of named variables through the Name Manager
Much improved flexibility in formatting graphs, which allow (x, y) coordinate labeling and lines of arbitrary weight.
Several improvements to pivot tables were introduced.
Office Open XML file formats were introduced, including .xlsm for a workbook with macros and .xlsx for a workbook without macros.
Specifically, many of the size limitations of previous versions were greatly increased. To illustrate, the number of rows was now 1,048,576 and columns was 16,384. This changes what is a valid A1 reference versus a named range.
This version made more extensive use of multiple cores for the calculation of spreadsheets; however, VBA macros are not handled in parallel and XLL add‑ins were only executed in parallel if they were thread-safe and this was indicated at registration.

Added to timeline:

Date:

1h 5min, jan 2, 2007 y
Now
~ 17 years ago

Images: