Microsoft Office 2010

Microsoft Office 2010

Microsoft Office 2010 applications from top left to bottom right: Word, Excel, PowerPoint and OneNote which collectively make up the Home and Student edition.
Developer(s)	Microsoft
Initial release	June 15, 2010; 14 years ago (2010-06-15)[1]
Final release	Service Pack 2 (14.0.7268.5000) / April 15, 2021; 3 years ago (2021-04-15)[2]
Operating system	Windows XP SP3 or later Windows Server 2003 SP2 or later[3][4]
Platform	IA-32 and x64
Predecessor	Microsoft Office 2007 (2007)
Successor	Microsoft Office 2013 (2013)
Available in	40 languages[5]
List of languages English, Arabic, Bulgarian, Chinese (Simplified), Chinese, Croatian, Czech, Danish, Dutch, Estonian, Filipino, Finnish, French, German, Greek, Hebrew, Hindi, Hungarian, Italian, Japanese, Kazakh, Korean, Latvian, Lithuanian, Norwegian (Bokmål), Polish, Portuguese (Brazil), Portuguese (Portugal), Romanian, Russian, Serbian, Slovak, Slovenian, Spanish, Swedish, Thai, Turkish, Ukrainian
Type	Office suite
License	Trialware
Website	products.office.com/office-2010

Microsoft Office 2010 (codenamed Office 14^[6]) is a version of Microsoft Office for Microsoft Windows unveiled by Microsoft on May 15, 2009, and released to manufacturing on April 15, 2010,^[1] with general availability on June 15, 2010.^[7] The macOS equivalent, Microsoft Office 2011 for Mac was released on October 26, 2010.

Office 2010 introduces user interface enhancements including a Backstage view that consolidates document management tasks into a single location. The ribbon introduced in Office 2007 for Access, Excel, Outlook, PowerPoint, and Word is the primary user interface for all applications in Office 2010 and is now customizable.^[8][9][10] Collaborative editing features that enable multiple users to share and edit documents;^[11] extended file format support;^[6] integration with OneDrive and SharePoint;^[11] and security improvements such as Protected View, a sandbox to protect users from malicious content^[12] are among its other new features. It debuted Office Online, free Web-based versions of Excel, OneNote, PowerPoint, and Word.^[13][14][15] A new Office Starter 2010 edition replaces Microsoft Works.^[16][17][18] Office Mobile 2010, an update to Microsoft's mobile productivity suite was released on May 12, 2010 as a free upgrade from the Windows Phone Store for Windows Mobile 6.5 devices with a previous version of Office Mobile installed.^[19][20][21]

Office 2010 is the first version of Office to ship in a 64-bit version.^[22][23] It is also the first version to require volume license product activation.^[24][25] Office 2010 is compatible with Windows XP SP3 and Windows Server 2003 SP2 through Windows 10 v1809 and Windows Server 2016.^[26][27] It is the last version of Microsoft Office to support Windows XP SP3, Windows Server 2003 SP2, Windows Vista SP1–SP2 and Windows Server 2008.^{[28][29][30][31]}

Reviews of Office 2010 were generally very positive, with praise to the new Backstage view, new customization options for the ribbon, and the incorporation of the ribbon into all programs.^[32][33] Sales, however, initially were lower than those of its predecessor.^[34] Despite this, Office 2010 was a success for Microsoft, surpassing the company's previous records for adoption,^[35] deployment,^[35] and revenue for Office.^[36] As of December 31, 2011, approximately 200 million licenses of Office 2010 were sold,^[37] before its discontinuation on January 31, 2013.^[38]

Mainstream support for Office 2010 ended on October 13, 2015, and extended support ended on October 13, 2020, the same dates that mainstream and extended support ended for Windows Embedded Standard 7.^[39] Office 2010 is the last version of Office that can be activated without enrolling in a Microsoft account; enrollment for activation is required starting with Office 2013.^[40] On June 9, 2018, Microsoft announced that its forums would no longer include Office 2010 or other products in extended support among its products for discussions involving support.^[41] On August 27, 2021, Microsoft announced that Outlook 2010 and Outlook 2007 would be cut off from connecting to Microsoft 365 Exchange servers on November 1, 2021.^[42]

History and development[edit]

Development started in 2007 while Microsoft was finishing work on Office 12, released as Microsoft Office 2007. The version number 13 was skipped because of the fear of the number 13.^[43] It was previously thought that Office 2010 (then called Office 14) would ship in the first half of 2009.^[44]

On April 15, 2009, Microsoft confirmed that Office 2010 would be released in the first half of 2010. They announced on May 12, 2009, at a Tech Ed event, a trial version of the 64-bit edition.^[45][46] The Technical Preview 1 (Version: 14.0.4006.1010) was leaked on May 15, 2009.^[47]

An internal post-beta build was leaked on July 12, 2009. This was newer than the official preview build and included a "Limestone" internal test application (note: the EULA indicates Beta 2).^[48] On July 13, 2009, Microsoft announced Office 2010 at its Worldwide Partner Conference 2009.

On July 14, 2009, Microsoft started to send out invitations on Microsoft Connect to test an official preview build of Office 2010.^[49] On August 30, 2009, the beta build 4417 was leaked on the internet via torrents.^[50]

The public beta was available to subscribers of TechNet, MSDN and Microsoft Connect users on November 16, 2009.^[51] On November 18, 2009, the beta was officially released to the general public at the Microsoft Office Beta website, which was originally launched by Microsoft on November 11, 2009 to provide screenshots of the new office suite.^[52] Office 2010 Beta was a free, fully functional version and expired on October 31, 2010.^[53]

In an effort to help customers and partners with deployment of Office 2010, Microsoft launched an Office 2010 application compatibility program with tools and guidance available for download.^[54] On February 5, 2010, the official release candidate build 4734.1000 was available to Connect and MSDN testers. It was leaked to torrent sites.^[55] A few days after, the RTM Escrow build was leaked.

Microsoft announced the RTM on April 15, 2010, and that the final version was to have speech technologies for use with text to speech in Microsoft OneNote, Microsoft PowerPoint, Microsoft Outlook, and Microsoft Word. Office 2010 was to be originally released to business customers on May 12, 2010,^[56] however it was made available to Business customers with Software Assurance on April 27, 2010, and to other Volume Licensing Customers on May 1.^[57] MSDN and TechNet subscribers have been able to download the RTM version since April 22, 2010. The RTM version number is 14.0.4763.1000.^[58][59] Office 2010 was launched for general customer availability on June 15, 2010.^[7][60]

Service packs[edit]

Microsoft released two service packs for Office 2010 that were primarily intended to address software bugs. Service Pack 1 (SP1) and Service Pack 2 (SP2) were released concurrently with updates for additional products including Office Online, SharePoint, and SharePoint Designer.^[62][63]

On November 17, 2010, Microsoft invited a select number of testers at the Microsoft Connect Web portal to test SP1 Beta 1.^[64][65] SP1 was released by Microsoft on June 27, 2011, and included compatibility, performance, security, and stability improvements. SP1 is a cumulative update that includes all previous updates, as well as fixes exclusive to its release;^[62][66] a list of exclusive fixes was released by Microsoft.^[67] SP1 also introduced additional features for Access, Excel, OneNote, Outlook, PowerPoint, and Word. As examples, OneNote 2010 SP1 introduced the ability to open notebooks stored in OneDrive directly from within the app itself, while Outlook 2010 SP1 introduced Microsoft 365 support.^[66] With the release of SP1, the use of Office Online in Google Chrome and Internet Explorer 9 was officially supported by Microsoft for the first time.^[68]

On April 8, 2013, a beta build of Office 2010 SP2 was released.^[69] SP2 was a cumulative update officially released on July 16, 2013, and included all of the previously released compatibility, performance, stability, and security fixes, as well as numerous exclusive fixes;^[63] a list of fixes exclusive to SP2 was released by Microsoft.^[70] Microsoft claimed that with the release of SP2, Office 2010 would feature improved compatibility with Internet Explorer 10, Office 2013, and SharePoint 2013.^[63][71] Because SP2 is cumulative, SP1 is not a prerequisite for its installation.^[72]

New features[edit]

User interface[edit]

In both its client programs and in its Internet implementation, the design of Office 2010 incorporates features from SharePoint and borrows from Web 2.0 ideas.^[73][74][75] Office 2010 is more "role-based" than previous versions of Microsoft Office, with specific features tailored to employees in "roles such as research and development professionals, sales people, and human resources."^[75]

Backstage view[edit]

A new Backstage view interface replaces the Office menu introduced in Office 2007 and is designed to facilitate access to document management and sharing tasks by consolidating them within a single location.^[76] In theatre, backstage refers to the area behind the stage where behind the scenes activities and preparations commence; the Backstage view is accordingly an interface dedicated to activities and preparations before saving or sharing a document.^[77] Backstage consists of both a left-hand navigation pane and an adjacent main pane; the navigation pane includes a series of vertically arranged common commands to open or save files, and tabs that, when opened, expose document management tasks and contextual information within the main pane.^[76][78] A customizable number of recently opened documents can also be displayed within the navigation pane.^[79]

Tasks that are accessed via tabs in the main Backstage pane are categorized into separate groups that display contextual information related to app configurations, files, and tasks; each tab displays information relevant to that specific tab. On the Info tab in Word, for example, document metadata details are displayed within the Prepare for Sharing group to inform users of potentially personal information before the file is shared with other users,^[80] whereas the Help tab displays Office 2010 version information and product licensing status.^[81] In Office 2007, this information was included within separate locations.^[80][81] From the Info tab, users can access revisions of currently open Excel, PowerPoint, and Word documents, as well as the latest unsaved version of a document that was previously closed.^[82] Within the Print tab, Backstage also combines the previously separate print and print preview features by displaying printer tasks, settings, and a zooming user interface to preview the currently open document without the user having to open a dialog box.^[83]

Backstage is extensible; developers can add their own commands, tabs, tasks, or related information.^[84][85][86]

File tab[edit]

The File tab replaces the Office button introduced in Office 2007 and offers similar functionality. The previous Office button—a round button adorned with the Microsoft Office 2007 logo—had a different appearance from the ribbon tabs in the Office 2007 interface and was positioned away from them, with a target that extended toward the upper left corner of the screen in accordance with Fitts's law.^[79][87] Microsoft stated this button enhanced the usability of Office, but many users saw it as "branding decoration, rather than a functional button." As a result, in Office 2010 it was replaced with a File tab that appears next to the other tabs in the ribbon instead of the upper left-hand corner of the screen.^[79] The File tab is colored on a per-app basis (e.g., it is colored orange in Outlook). Opening the File tab displays the new Backstage view.^[88]

Pasting options gallery[edit]

Office 2010 introduces a pasting options gallery on the ribbon, in the context menu, and in the object-oriented user interface that replaces the Paste Special dialog box and Paste Recovery feature seen in previous versions of Office. The gallery introduces Live Preview effects to the paste process when users position the mouse cursor over an option in the gallery so that the result of the process can be previewed before it is applied to the document; a tooltip with an associated description and keyboard shortcut for that option will also appear. If users position the mouse cursor over a gallery option in the context menu, the rest of the context menu becomes transparent so that it does not obstruct preview results within the document. To facilitate keyboard-based paste operations, users can navigate the gallery by using the arrow keys on a keyboard or press Ctrl after pressing Ctrl+V to display gallery options. Gallery options change based on the content in the clipboard and the app into which the content is pasted.^[89]

Ribbon improvements[edit]

The ribbon introduced in Office 2007 is fully customizable and included in all programs in Office 2010.^[8][9] Users can add or rename custom ribbon tabs or groups, add additional commands to the default tabs, and hide tabs that are not used. Users can also export or import any customization changes made to the ribbon to facilitate backups, deployment, or sharing, or reset all ribbon customizations.^[90] The ribbon was also updated with a visible interface option to minimize it, which leaves only the tabs exposed.^[91]

After the launch of Office 2010, Microsoft provided free downloads for a new Favorites tab that consolidated commands based on customer feedback regarding the most frequently used commands in all Office programs.^[92]

Other UI changes[edit]

• The default color scheme in Office 2010 is silver instead of blue as in Office 2007 and now features a 5:1 contrast ratio to improve accessibility and readability.^[88]
• All app icons have been redesigned in Office 2010. The new icons are based on colors that correspond to their respective programs, as per previous releases, with an increased emphasis on app letters.^[88]
• The Office 2010 splash screen has been redesigned from the one seen in Office 2007 and animates when an app is launched.^[88]
• OneNote and PowerPoint support mathematical equations through an Equation Tools contextual tab on the ribbon.^[93][94]
• PowerPoint and Publisher include alignment guides so users can align objects to a grid.^[94][95]
• Smart tags introduced in Office XP have been renamed as Actions and are now accessible from the context menu.^[96]

File formats[edit]

Office 2010 includes updated support for ISO/IEC 29500, the International Standard version of Office Open XML (OOXML) file format.^[6] Office 2010 provides read support for ECMA-376, read/write support for ISO/IEC 29500 Transitional, and read support for ISO/IEC 29500 Strict.^[97] In its pre-release form, however, Office 2010 only supported the Transitional variant, and not the Strict.^[98]

Office 2010 also continued support for OpenDocument Format (ODF) 1.1, which is a joint OASIS/ISO/IEC standard (ISO/IEC 26300:2006/Amd 1:2012 — Open Document Format for Office Applications (OpenDocument) v1.1).^[6]

Document co-authoring[edit]

Office 2010 introduces co-authoring functionality in the Excel Web App, the OneNote Web App, and in the client versions of OneNote, PowerPoint, and Word for documents stored on SharePoint 2010 sites and for shared documents in OneDrive^[11] and Microsoft 365.^[99] A co-authoring session is automatically initiated when two or more users open the same document. From Backstage within Excel, OneNote, PowerPoint, and Word, users can also save documents directly to remote locations to facilitate remote access and co-authoring sessions. In the Excel Web App, the OneNote, and the OneNote Web App edits to a shared document in a co-authoring session occur on a sequential basis, in near real-time, as shared documents save automatically with each edit. In PowerPoint and Word, however, users must upload changes to the server by manually saving the shared document.^[11]

During a co-authoring session the Excel Web App, PowerPoint, and Word denote how many co-authors are editing a document through a status bar icon that, when clicked in PowerPoint and Word, displays contact information including the presence of co-authors; the Info tab of Backstage also displays these details. When users open the name of a co-author, they can send email with an email client or start instant messaging conversations with each other if a supported app such as Skype for Business is installed on each machine. If a conflict between multiple changes occurs in PowerPoint or Word, sharers can approve or reject changes before uploading them to the server.^[11]

In both OneNote and the OneNote Web App, users can view the names of co-authors alongside their respective edits to the content in a shared notebook, or create separate versions of pages for individual use. Edits made since a notebook was last opened are automatically highlighted, with initials of the co-author who made the edit displayed. In OneNote, co-authors can also search for all edits made by a specific co-author. OneNote 2010 notebooks can be shared with Office Mobile 2010 users on Windows Phone 7.^[11] OneNote 2007 users can also participate in a co-authoring session with OneNote 2010 users if shared notebooks use the older OneNote 2007 file format; however, co-author search, and page versioning, and compatibility with the OneNote Web App will not be available.^[100]

Installation and deployment[edit]

Office 2010 introduces a new Click-to-Run installation process based on Microsoft App-V Version 4 streaming and virtualization technology as an alternative to the traditional Windows Installer-based installation process for the Home and Student and Home and Business editions, and as a mandatory installation process for the Starter edition. Click-to-Run products install in a virtualized environment (a Q: partition) that downloads product features in the background after the programs have been installed so that users can immediately begin using the programs. The download process is optimized for broadband connections.^[101]

During the Office 2010 retail lifecycle Microsoft, in collaboration with original equipment manufacturers (OEMs) and retail partners, introduced a Product Key Card licensing program that allowed users to purchase a single license to activate Home and Student, Home and Business, and Professional editions preinstalled on personal computers at a reduced cost when compared with traditional retail media.^[102] Product Key Card versions are restricted to a single machine.^[103]

Volume license versions of Office 2010 require product activation. Office 2007's product activation was only required for OEM or retail versions of the product.^[24]

Security[edit]

Office File Validation[edit]

Office File Validation, previously included only in Publisher 2007 for PUB files has been incorporated into Excel, PowerPoint, and Word in Office 2010 to validate the integrity of proprietary binary file formats (e.g., DOC, PPT, and XLS) introduced in previous versions of Microsoft Office. When users open a document, the structure of its file format is scanned to ensure that it conforms with specifications defined by XML schema; if a file fails the validation process it will, by default, be opened in Protected View, a new read-only, isolated sandbox environment to protect users from potentially malicious content.^[104] this design allows users to visually assess potentially unsafe documents that fail validation.^[105] Microsoft stated that it is possible for documents to fail validation as a false positive. To improve Office File Validation, Office 2010 collects various information about files that have failed validation and also creates copies of these files for optional submission to Microsoft through Windows Error Reporting.^[104] Users are prompted approximately every two weeks from the date of a failed validation attempt to submit copies of files or of other information for analysis; prompts include a list of files that will be submitted to Microsoft and require explicit user consent prior to submission. Administrators can disable data submission.^[106]

On December 14, 2010, Microsoft announced it would backport Office File Validation to Office 2003 and Office 2007.^[107][108] On April 12, 2011, it was backported as an add-in for Office 2003 SP3 and Office 2007 SP2, and on June 28, 2011, was made available through Microsoft Update.^[109] Office File Validation in Office 2003 and Office 2007 differs from the version in Office 2010 as these two releases do not include the Protected View feature. When users attempt to open a document that fails validation, they must first agree to a warning prompt before it can be opened.^[109] Additionally, the configuration options in these two releases are only made available through the Windows Registry,^[110] whereas Office 2010 also provides Group Policy options.^[104]

Protected View[edit]

Protected View, an isolated sandbox environment for Excel, PowerPoint, and Word, replaces the Isolated Conversion Environment update available for previous versions of Microsoft Office. When a document is opened from