Editing Microsoft Excel (section)

==== Excel 2007 (v12.0) ====
[[File:Microsoft Office Excel 2007.png|thumb|Microsoft Excel 2007]]
Included in [[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 for highly experienced users and users of word processing applications with a classical [[WIMP interface]], but was less convinced in terms of efficiency and organization.<ref>{{cite book|url=http://www.wseas.us/e-library/conferences/2010/Faro/DNCOCO/DNCOCO-25.pdf|title=User Acceptance of the Microsoft Ribbon User Interface|publisher=[[Palacký University of Olomouc]]|first=M|last=Dostál|isbn=978-960-474-245-5|issn=1792-6157|date=December 9, 2010|access-date=May 28, 2013|archive-date=February 26, 2013|archive-url=https://web.archive.org/web/20130226223646/http://www.wseas.us/e-library/conferences/2010/Faro/DNCOCO/DNCOCO-25.pdf|url-status=live}}</ref> 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.

Added functionality included Tables,<ref>{{Cite web|title=Using Excel Tables to Manipulate Billing Data|url=https://mooresolutionsinc.com/downloads/Billing_MJ12.pdf|url-status=dead|archive-url=https://web.archive.org/web/20230322064704/https://mooresolutionsinc.com/downloads/Billing_MJ12.pdf|archive-date=March 22, 2023|access-date=February 22, 2024}}</ref> and the [[Microsoft Office 2007#SmartArt|SmartArt]] set of editable business diagrams. Also added was an improved management of named variables through the ''Name Manager'', and much-improved flexibility in formatting graphs, which allow (''x, y'') coordinate labeling and lines of arbitrary weight. Several improvements to pivot tables were introduced.

Also like other office products, the Office Open XML file formats were introduced, including ''.xlsm'' for a workbook with macros and ''.xlsx'' for a workbook without macros.<ref name="Dodge">{{cite book|title=Microsoft Office Excel 2007 inside out|first1=Mark|last1=Dodge|first2=Craig|last2=Stinson|year=2007|publisher=Microsoft Press|isbn=978-0-7356-2321-7|chapter=Chapter 1: What's new in Microsoft Office Excel 2007|page=1 ''ff''}}</ref>

Specifically, many of the size limitations of previous versions were greatly increased. To illustrate, the number of rows was now 1,048,576 (2<sup>20</sup>) and the columns was 16,384 (2<sup>14</sup>; the far-right column is XFD). This changes what is a valid ''A1''&nbsp;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 safety|thread-safe]] and this was indicated at registration.