Skip to content

Office 2007 Vs Office 2010 Comparison Essay

Microsoft Office 2007 applications shown on Windows 10 (clockwise from top left: Excel, Word, OneNote, PowerPoint; these four programs make up the Home and Student Edition)

Developer(s)Microsoft
Initial releaseJanuary 30, 2007; 11 years ago (2007-01-30)[1]
Stable release

Service Pack 3 (12.0.6612.1000)[2] / October 25, 2011; 6 years ago (2011-10-25)

Development statusMainstream support ended on October 9, 2012.[3]
Extended support ended on October 10, 2017.[3]
Operating systemWindows XP SP2, Windows Server 2003 SP1, or later operating system[4]
PlatformIA-32[4]
Available inEnglish, Arabic, Simplified Chinese, Traditional Chinese, Czech, Danish, Dutch, Finnish, French, German, Greek, Hebrew, Hindi, Hungarian, Italian, Japanese, Korean, Lithuanian, Norwegian (Bokmål), Polish, Portuguese, Romanian, Russian, Slovak, Slovenian, Spanish, Swedish, Thai, Turkish, and Ukrainian.[5]
TypeOffice suite
LicenseTrialware
Websiteproducts.office.com/download-office-2007

Microsoft Office 2007 (codenamed Office 12[6]) is a version of Microsoft Office, a family of office suites and productivity software for Windows, developed and published by Microsoft. It was released to manufacturing on November 3, 2006;[7] it was subsequently made available to volume license customers on November 30, 2006,[8][9] and later to retail on January 30, 2007,[1] the same respective release dates of Windows Vista. It was preceded by Office 2003 and succeeded by Office 2010.

Office 2007 introduced a new graphical user interface called the Fluent User Interface, which uses ribbons and an Office menu instead of menu bars and toolbars.[10] Office 2007 also introduced Office Open XML file formats as the default file formats in Excel, PowerPoint, and Word. The new formats are intended to facilitate the sharing of information between programs, improve security, reduce the size of documents, and enable new recovery scenarios.[11]

Office 2007 requires Windows XP with Service Pack 2, Windows Server 2003 with Service Pack 1, or a later operating system; it is the last version of Microsoft Office to support Windows XP Professional x64 Edition.[4]

Office 2007 includes new applications and server-side tools, including Microsoft Office Groove, a collaboration and communication suite for smaller businesses, which was originally developed by Groove Networks before being acquired by Microsoft in 2005. Also included is Office SharePoint Server 2007, a major revision to the server platform for Office applications, which supports Excel Services, a client-server architecture for supporting Excel workbooks that are shared in real time between multiple machines, and are also viewable and editable through a web page.

With Microsoft FrontPage discontinued, Microsoft SharePoint Designer, which is aimed towards development of SharePoint portals, becomes part of the Office 2007 family. Its designer-oriented counterpart, Microsoft Expression Web, is targeted for general web development. However, neither application has been included in Office 2007 software suites.

Speech recognition functionality has been removed from the individual programs in the Office 2007 suite, as Windows Speech Recognition was integrated into Windows Vista. Windows XP users must install a previous version of Office to use speech recognition features.[12]

According to Forrester Research, as of May 2010, Microsoft Office 2007 is used in 81% of enterprises it surveyed (its sample comprising 115 North American and European enterprise and SMB decision makers).[13]

Development[edit]

The first beta of Microsoft Office 2007, referred to as Beta-1 in emails sent to a small number of testers, was released on November 16, 2005. The Beta-1 Technical Refresh was released to testers on March 13, 2006. The Technical Refresh fixed issues in installing with Windows Vista build 5308.

Microsoft revealed the ribbon on March 9, 2006 at CeBIT in Germany.[14]

Office 2007 Beta 2 was announced by Bill Gates at WinHEC 2006, and was initially released to the public at no cost from Microsoft's web site. However, because of an unprecedented number of downloads, a fee of $1.50 was introduced for each product downloaded after August 2, 2006. The beta was updated on September 14, 2006 in Beta 2 Technical Refresh (Beta2TR). It included an updated user interface, better accessibility support, improvements in the robustness of the platform, and greater functionality.

The beta versions continued to function in a reduced functionality mode after February 1, 2007. If users downloaded the Technical Refresh to update Beta 2, then users could use its full functionality until March 31, 2007 for client products and May 15, 2007 for server products. The Beta program ended on November 8, 2006, when Microsoft declared the product "Released to Manufacturing" (RTM) and started manufacturing the final product. After RTM, the availability of the beta download ended.

Office 2007 was released to volume licensing customers on November 30, 2006, and to the general public on January 30, 2007.[1]

Service packs[edit]

Since the initial release of Microsoft Office 2007, three service packs containing updates as well as additional features have been released. Microsoft Office 2007 Service Packs are cumulative, so previous Service Packs are not a prerequisite for installation.[15]

Microsoft Office 2007 Service Pack 1 was released on December 11, 2007.[16] Official documentation claims that SP1 is not simply a rollup of publicly released patches, but that it also contains fixes for a total of 481 issues throughout the entire Office suite.[17] Microsoft Office 2007 Service Pack 2 was released on April 28, 2009.[18] It added improved support for ODF, XPS and PDF standards, and included several bug fixes.[18][19] Microsoft Office 2007 Service Pack 3 was released on October 25, 2011.[20]

Editions[edit]

Programs and FeaturesBasicHome and StudentStandardSmall BusinessProfessionalProfessional PlusUltimateEnterprise
Licensing schemeOEMOEM and retailRetail and volumeOEM, retail, and volumeOEM and retailVolumeRetailVolume
WordYesYesYesYesYesYesYesYes
ExcelYesYesYesYesYesYesYesYes
PowerPointViewer onlyYesYesYesYesYesYesYes
OutlookYesNoYesYesYesYesYesYes
PublisherNoNoNoYesYesYesYesYes
AccessNoNoNoNoYesYesYesYes
InfoPathNoNoNoNoNoYesYesYes
CommunicatorNoNoNoNoNoYesNoYes
GrooveNoNoNoNoNoNoYesYes
OneNoteNoYesNoNoNoNoYesYes
ProjectNoNoNoNoNoNoNoNo
SharePoint DesignerNoNoNoNoNoNoNoNo
VisioViewer onlyViewer onlyViewer onlyViewer onlyViewer onlyViewer onlyViewer onlyViewer only
Office Customization Tool (OCT)1NoNoVolume licensing only[23]Volume licensing only[23]NoYes[23]NoYes[23]
Upgrade MSRP?N/A$239.95[22]$279.95[22]$329.95[22]?$539.95[22]?
Full MSRP?$149.95[22]$399.95[22]$449.95[22]$499.95[22]?$679.95[22]?
1 Office Customization Tool is used to customize the installation of Office 2007 by creating a Windows Installer patch file (.MSP) and replacing the Custom Installation Wizard and Custom Deployment Wizard included in earlier versions of the Office Resource Kit that created a Windows Installer Transform (.MST).[23]

Volume licensing[edit]

Eligible employees of companies with volume license agreements for Microsoft Office receive additional tools, including enterprise content management, electronic forms, Information Rights Management capabilities and copies for use on a home computer.[24]

New features[edit]

User interface[edit]

The new user interface (UI), officially known as Fluent User Interface,[25][26] has been implemented in the core Microsoft Office applications: Word, Excel, PowerPoint, Access, and in the item inspector used to create or edit individual items in Outlook. These applications have been selected for the UI overhaul because they center around document authoring.[27] The rest of the applications in the suite changed to the new UI in subsequent versions.[28] The default font used in this edition is Calibri. Original prototypes of the new user interface were revealed at MIX 2008 in Las Vegas.[29]

Office button[edit]

The Office 2007 button, located on the top-left of the window, replaces the File menu and provides access to functionality common across all Office applications, including opening, saving, printing, and sharing a file. It can also close the application. Users can also choose color schemes for the interface. A notable accessibility improvement is that the Office button follows Fitts's law.[30]

Ribbon [edit]

Main article: Ribbon (computing)

The ribbon, a panel that houses a fixed arrangement of command buttons and icons, organizes commands as a set of tabs, each grouping relevant commands. The ribbon is present in Microsoft Word 2007, Excel 2007, PowerPoint 2007, Access 2007 and some Outlook 2007 windows. The ribbon is not user customizable in Office 2007. Each application has a different set of tabs that exposes functions that the application offers. For example, while Excel has a tab for the graphing capabilities, Word does not; instead it has tabs to control the formatting of a text document. Within each tab, various related options may be grouped together. The ribbon is designed to make the features of the application more discoverable and accessible with fewer mouse clicks[31] as compared to the menu-based UI used prior to Office 2007. Moving the mouse scroll wheel while on any of the tabs on the ribbon cycles—through the tabs. The ribbon can be minimized by double clicking the active section's title, such as the Home text in the picture below.[32] Office 2007 does not natively support removing, modifying or replacing ribbon. Third party add-ins, however, can bring menus and toolbars back to Office 2007 or customize the ribbon commands. Add-ins that restore menus and toolbars include Classic Menu for Office,[33] ToolbarToggle,[34][35] and Ubitmenu.[36] Others like RibbonCustomizer enable the customization of ribbons.[35] Office 2010 does allow user customization of the ribbon out of the box.

Contextual Tabs[edit]

Some tabs, called Contextual Tabs, appear only when certain objects are selected. Contextual Tabs expose functionality specific only to the object with focus. For example, selecting a picture brings up the Pictures tab, which presents options for dealing with the picture. Similarly, focusing on a table exposes table-related options in a specific tab. Contextual Tabs remain hidden except when an applicable object is selected.

Live Preview[edit]

Microsoft Office 2007 also introduces a feature called Live Preview, which temporarily applies formatting on the focused text or object when any formatting button is moused-over. The temporary formatting is removed when the mouse pointer is moved from the button. This allows users to have a preview of how the option would affect the appearance of the object, without actually applying it.

Mini Toolbar[edit]

The new Mini Toolbar is a small toolbar with basic formatting commands that appears within the document editing area, much like a context menu. When the mouse selects part of the text, Mini Toolbar appears close to selected text. It remains semi-transparent until the mouse pointer is hovered on it, to avoid obstructing what is underneath. Mini Toolbar can also be made to appear by right-clicking in the editing area or via key on keyboard, in which case it appears near the cursor, above or below the traditional context menu. Mini Toolbar is not customizable in Office 2007, but can be turned off.

Quick Access Toolbar[edit]

The Quick Access toolbar (by default) sits in the title bar and serves as a repository of most used functions, such as save, undo/redo and print. It is customizable, although this feature is limited, compared to toolbars in previous Office versions. Any command available in the entire Office application can be added to the Quick Access toolbar, including commands not available on the ribbon as well as macros. Keyboard shortcuts for any of the commands on the toolbar are also fully customizable, similar to previous Office versions.

Other UI features[edit]

  • Super-tooltips, or screentips, that can house formatted text and even images, are used to provide detailed descriptions of what most buttons do.
  • A zoom slider present in the bottom-right corner, allowing for dynamic and rapid magnification of documents.
  • The status bar is fully customizable. Users can right click the status bar and add or remove what they want the status bar to display.[37]

SmartArt[edit]

SmartArt, found under the Insert tab in the ribbon in PowerPoint, Word, Excel, and Outlook, is a new group of editable and formatted diagrams. There are 115 preset SmartArt graphics layout templates in categories such as list, process, cycle, and hierarchy. When an instance of a SmartArt is inserted, a Text Pane appears next to it to guide the user through entering text in the hierarchical levels. Each SmartArt graphic, based on its design, maps the text outline, automatically resized for best fit, onto the graphic. There are a number of "quick styles" for each graphic that apply largely different 3D effects to the graphic, and the graphic's shapes and text can be formatted through shape styles and WordArt styles. In addition, SmartArt graphics change their colors, fonts, and effects to match the document's theme.

File formats[edit]

Office Open XML[edit]

Main article: Office Open XML

Microsoft Office 2007 introduced a new file format, called Office Open XML, as the default file format. Such files are saved using an extra X letter in their extension (.docx/xlsx/pptx/etc.). However, it can still save documents in the old format, which is compatible with previous versions. Alternatively, Microsoft has made available a free add-on known as the Microsoft Office Compatibility Pack that lets Office 2000, XP, and 2003 open, edit, and save documents created under the newer 2007 format.[38]

Office Open XML is based on XML and uses the ZIP file container. According to Microsoft, documents created in this format are up to 75% smaller than the same documents saved with previous Microsoft Office file formats, owing to the ZIP data compression.[39]

Files containing macros are saved with an extra M letter in their extension instead (.docm/xlsm/pptm/etc.).

PDF[edit]

Initially, Microsoft promised to support exporting to Portable Document Format (PDF) in Office 2007. However, due to legal objections from Adobe Systems, Office 2007 originally did not offer PDF support out of the box, but rather as a separate free download.[40][41][42] However, starting with Service Pack 2, Office allows users to natively export PDF files.[43]

XPS[edit]

Office 2007 documents can also be exported as XPS documents. This is part of Service Pack 2 and prior to that, was available as a free plug-in in a separate download.[43][44]

OpenDocument[edit]

Main article: OpenDocument software

Microsoft backs an open-source effort to support OpenDocument in Office 2007, as well as earlier versions (up to Office 2000), through a converter add-in for Word, Excel and PowerPoint, and also a command-line utility.[45] As of 2008, the project supports conversion between ODF and Office Open XML file formats for all three applications.[46] According to ODF Alliance this support falls short and substantial improvements are still needed for interoperability in real-world situations.[47][48] Third-party plugins able to read, edit and save to the ISO-standard Open Document Format (ODF) are available as a separate download.[49][50]

Office 2007 Service Pack 2 adds native support for the OpenDocument Format.[51] The ODF Alliance has released test results on ODF support of Office 2007 SP2,[52] concluding that Office ODF support, both SP2 and other add-ons, have "serious shortcomings that, left unaddressed, would break the open standards based interoperability that the marketplace, especially governments, is demanding". Particularly, SP2 has no support for encrypted ODF files and has limited interoperability with other ODF spreadsheet implementations.

The ISO/IEC 26300 OpenDocument standard specifies encryption of files, which is based on sha1, Blowfish, and RFC 2898. Microsoft Office 2007 SP2 does not support reading and writing encrypted (password protected) ODF files.[52][53][54] Users are presented with a message: “cannot use password protection using the ODF format.”[52][54]

The ISO/IEC 26300 OpenDocument standard has no spreadsheet formula language included (or referenced) in the standard specification. Office 2007 SP2 uses the spreadsheet formula language specified in the ISO/IEC 29500 Office Open XMLopen standard when creating ODF documents. According to the ODF Alliance report "ODF spreadsheets created in Excel 2007 SP2 do not in fact conform to ODF 1.1 because Excel 2007 incorrectly encodes formulas with cell addresses. Section 8.3.1 of ODF 1.1 says that addresses in formulas "start with a "[" and end with a "]"." In Excel 2007 cell addresses were not enclosed with the necessary square brackets."[52] The ISO/IEC 26300 specification states that the semantics and the syntax depends on the used namespace, which is implementation dependent, leaving the syntax implementation defined as well.[55]

Microsoft stated that they consider adding support for an official ODF formula language (OpenFormula), once a future version of the ISO/IEC 26300 standard specification includes one.[56]

Microsoft's ODF spreadsheet support in SP2 is not fully inter-operable with other implementations of OpenDocument, such as the IBM Symphony, which use the non-standardized OpenOffice.org 2.x formula language, and OpenOffice.org 3.x, which uses a draft of OpenFormula.[57] The company had previously reportedly stated that "where ODF 1.1 is ambiguous or incomplete, the Office implementation can be guided by current practice in OpenOffice.org, mainly, and other implementations including KOffice and AbiWord. Peter Amstein and the Microsoft Office team are reluctant to make liberal use of extension mechanisms, even though provided in ODF 1.1. They want to avoid all appearance of an embrace-extend attempt."[58]

The EU investigated Microsoft Office OpenDocument Format support to see if it provided consumers greater choice.[59]

Metadata[edit]

In Office 2007, Microsoft introduced the Document Inspector, an integral metadata removal tool that strips Word, Excel, and PowerPoint documents of information such as author name and comments and other "metadata".

User assistance system[edit]

In Microsoft Office 2007, the Office Assistants have been eliminated in favour of a new online help system. One of its features is the extensive use of Super Tooltips, which explain in about one paragraph what each function performs. Some of them also use diagrams or pictures. These appear and disappear like normal tooltips, and replace normal tooltips in many areas. The Help content also directly integrates searching and viewing Office Online articles.

Collaboration features[edit]

SharePoint[edit]

Microsoft Office 2007 includes features geared towards collaboration and data sharing. As such, Microsoft Office 2007 features server components for applications such as Excel, which work in conjunction with SharePoint Services, to provide a collaboration platform. SharePoint works with Microsoft Office SharePoint Server 2007, which is used to host a SharePoint site, and uses IIS and ASP.NET 2.0. Excel server exposes Excel Services, which allows any worksheet to be created, edited and maintained via web browsers. It features Excel Web Access, the client-side component which is used to render the worksheet on a browser, Excel Calculation Service which is the server side component which populates the worksheet with data and perform calculations, and Excel Web Services that extends Excel functionalities into individual web services. SharePoint can also be used to host Word documents for collaborative editing, by sharing a document. SharePoint can also be used to hold PowerPoint slides in a Slide Library, from which the slides can be used as a formatting template. It also notifies users of a slide automatically in case the source slide is modified. Also by using SharePoint, PowerPoint can manage shared review of presentations. Any SharePoint hosted document can be accessed from the application which created the document or from other applications such as a browser or Microsoft Office Outlook.

Groove[edit]

Microsoft Office 2007 also includes Groove, which brings collaborative features to a peer-to-peer paradigm. Groove can host documents, including presentations, workbooks and others, created in Microsoft Office 2007 application in a shared workspace, which can then be used in collaborative editing of documents. Groove can also be used in managing workspace sessions, including access control of the workspace. To collaborate on one or more documents, a Workspace must be created, and then those who are to work on it must be invited. Any file shared on the workspace are automatically shared among all participants. The application also provides real-time messaging, including one-to-one as well as group messaging, and presence features, as well as monitoring workspace activities with alerts, which are raised when pre-defined set of activities are detected. Groove also provides features for conflict resolution for conflicting edits. Schedules for a collaboration can also be decided by using a built-in shared calendar, which can also be used to keep track of the progress of a project. However, the calendar is not compatible with Microsoft Outlook.

Themes and Quick Styles[edit]

Microsoft Office 2007 places more emphasis on Document Themes and Quick Styles. The Document Theme defines the colors, fonts and graphic effects for a document. Almost everything that can be inserted into a document is automatically styled to match the overall document theme creating a consistent document design. The new Office Theme file format (.THMX) is shared between Word, Excel, PowerPoint and Outlook email messages. Similar themes are also available for data reports in Access and Project or shapes in Visio.

Quick Styles are galleries with a range of styles based on the current theme. There are quick styles galleries for text, tables, charts, SmartArt, WordArt and more. The style range goes from simple/light to more graphical/darker.

Application-specific changes[edit]

Word[edit]

Main article: Microsoft Word

  • New style sheets (quick styles) and ability to switch easily among them.
  • Default Font now 'Calibri' instead of 'Times New Roman', as featured in previous versions of Microsoft Office.
  • Word count listed by default in the status bar. The word count dynamically updates as you type.
  • New contextual spell checker, signified by a wavy blue underline to the traditional wavy red underline for misspellings and wavy green underline for grammar errors, sometimes catches incorrect usage of correctly spelled words, such as in "I think we will loose this battle".
  • Translation tool tip option available for English (U.S.), French (France), and Spanish (International Sort). When selected, hovering the mouse cursor over a word displays its translation in the particular language. Non-English versions have different sets of languages. Other languages can be added by using a separate multilingual pack.
  • Automated generation of citations and bibliographies according to defined style rules, including APA, Chicago, and MLA. Changing style updates all references automatically. Connect to web services to access online reference databases.
  • Redesigned native mathematical equation support with TeX-like linear input/edit language or GUI. Also supports the Unicode Plain Text Encoding of Mathematics.[60]
  • Preset gallery of cover pages with fields for Author, Title, Date, Abstract, etc. Cover pages follow the theme of the document (found under the Page Layout tab).
  • Document comparison engine updated to support moves, differences in tables, and also easy to follow tri-pane view of original document, new document, and differences.
  • Full screen reading layout that shows two pages at a time with maximal screen usage, plus a few critical tools for reviewing.
  • Building Blocks, which lets one save frequently used content, so that they are easily accessible for further use. Building blocks can have data mapped controls in them to allow for form building or structured document authoring.
  • The ability to save multiple versions of a document (which had existed since Word 97) has been removed.[61]
  • Blog entries[62] can be authored in Word itself and uploaded directly to a blog. Supported blogging sites include Windows Live Spaces, WordPress, SharePoint, Blogger, Telligent Community etc.
  • Drops function for Insert/Picture/From Scanner or Camera. Can be added manually.[63]
  • Drops the "Bullets and Numbering" dialog boxes and rich, easily controlled range of options for formatting Outline Numbered lists

Outlook[edit]

Main article: Microsoft Outlook

  • As a major change in Outlook 2007, Exchange 5.5 support has been dropped. Like Evolution, Outlook Express and Entourage, Outlook now works only with Exchange 2000 and above.
  • Outlook now indexes (using the Windows Search APIs) the e-mails, contacts, tasks, calendar entries, RSS feeds and other items, to speed up searches. As such, it features word-wheeled search, which displays results as characters are typed.[64][65]
  • Search folders, which are saved searches, have been updated to include RSS feeds as well. Search folders can be created with a specific search criteria, specifying the subject, type and other attributes of the information being searched. When a search folder is opened, all matching items for the search are automatically retrieved and grouped up.
  • Outlook now supports text-messages and SMSs, when used in conjunction with Exchange Server 2007 Unified Messaging.
  • Outlook includes a reader for RSS feeds, which use the Windows Common Feeds Store. RSS subscription URLs can be shared via e-mails; updates can also be pushed to a mobile device.
  • Outlook can now support multiple calendars being worked with simultaneously. It also includes a side-by-side view for calendars, where each calendar is displayed in a different tab, and allows easy comparison of them. Outlook also supports web calendars. Calendars can be shared with other users, and also exported as a HTML file for viewing by others who do not have Outlook installed.
  • Calendar view shows which tasks are due.
  • Flagged e-mails and notes can also be converted to Task items.
  • Outlook includes a To Do Bar, which consolidates appointment, calendar, and task items in a single view.[65]
  • Outlook includes a Windows SideShow Calendar Gadget
  • Online or offline editing of all Microsoft Office 2007 documents via a SharePoint site. All edits are automatically synchronized.
  • Contacts can be shared among users, via e-mail, Exchange Server or a SharePoint site.
  • Attachment preview allows users to view Office e-mail attachments in the reading pane rather than having to open another program.[65]
  • HTML in e-mails is now rendered using the Microsoft Word rendering engine which disallows several HTML tags like object, script, iframe etc. along with several CSS properties.

Microsoft Office Outlook can also include an optional Business Contact Manager (included on a separate installation disc in Office 2007 Small Business and above) which allows management of business contacts and their sales and marketing activities. Phone calls, e-mails, appointments, notes and other business metrics can be managed for each contact. It can also keep a track of billable time for each contact on the Outlook Calendar. Based on these data, a consolidated report view can be generated by Microsoft Office Outlook with Business Contact Manager. The data can be further analyzed using Microsoft Office Excel. This data can also be shared using SharePoint Services.

Excel[edit]

Main article: Microsoft Excel

  • Support up to 1,048,576 rows and 16,384 columns (XFD) in a single worksheet, with 32,767 characters in a single cell (17,179,869,184 cells in a worksheet, 562,932,773,552,128 characters in a worksheet)[67]
  • Conditional Formatting introduces support for three new features — Color Scales, Icon Sets and Data Bars
    • Color Scales, which automatically color the background of a group of cells with different colors according to the values.
    • Icon sets, which precede the text in a cell with an icon that represent some aspect of the value of the cell with respect to other values in a group of cells, can also be applied. Icons can be conditionally applied to show up only when certain criteria are met, such as a cross showing up on an invalid value, where the condition for invalidity can be specified by the user.
    • Data Bars show as a gradient bar in the background of a cell the contribution of the cell value in the group.
  • Column titles can optionally show options to control the layout of the column.
  • Multithreaded calculation of formulae, to speed up large calculations, especially on multi-core/multi-processor systems.
  • User Defined Functions (UDF), which are custom functions written to supplement Excel's set of built-in functions, supports the increased number of cells and columns. UDFs now can also be multithreaded. Server side UDFs are based on the .NET Managed code.
  • Importing data from external sources, such as a database, has been upgraded. Data can also be imported from formatted tables and reports, which do not have a regular grid structure
  • Formula Autocomplete, automatically suggests function names, arguments and named ranges, and automatically completing them if desired, based on the characters entered. Formulae can refer to a table as well
  • CUBE functions which allow importing data, including set aggregated data, from data analysis services, such as SQL Server Analysis Services
  • Page Layout view, to author spreadsheets in a way that mirrors the formatting of the printed document
  • PivotTables, which are used to create analysis reports out of sets of data, can now support hierarchical data by displaying a row in the table with a "+" icon, which, when clicked, shows more rows regarding it, which can also be hierarchical. PivotTables can also be sorted and filtered independently, and conditional formatting used to highlight trends in the data.
  • Filters, now includes a Quick filter option allowing the selection of multiple items from a drop down list of items in the column. The option to filter based on color has been added to the choices available.
  • Excel features a new charting engine, which supports advanced formatting, including 3D rendering, transparencies and shadows. Chart layouts can also be customized to highlight various trends in the data.

PowerPoint[edit]

Main article: Microsoft PowerPoint

  • Improvements to text rendering to support text based graphics.
  • Rendering of 3D graphics.
  • Support for many more sound file formats such as .mp3 and .wma.
  • Support for tables and enhanced support for table pasting from Excel.[68]
  • Slide Library, which lets you reuse any slide or presentation as a template. Any presentation or slide can be published to the Slide Library.
  • Any custom-designed slide library can be saved.
  • Presentations can be digitally signed.
  • Improved Presenter View.[69]
  • Added support for widescreen slides.[70]
  • Allows addition of custom placeholders.
  • Drops function for Insert/Picture/From Scanner or Camera.
  • Allows for duplication of a slide through right-clicking it without having to go through Copy and Paste

OneNote[edit]

Main article: Microsoft OneNote

  • OneNote now supports multiple notebooks.[71]
  • Notebooks can be shared across multiple computers. Anyone can edit even while not connected and changes are merged automatically across machines when a connection is made. Changes are labeled with author and change time/date.[71][72][73]
  • Notebook templates.[71]
  • Word-wheeled search is also present in OneNote, which also indexes notes.[71]
  • Synchronization of Tasks with Outlook 2007. Also Outlook can send mails to OneNote, or open pages in OneNote that are linked to tasks, contacts, appointments/meetings.[71][74]
  • Support for tables. Using tabs to create tabular structure automatically converts it to a table.[71]
  • Optical character recognition is performed on images (e.g., brochures, photos, prints, scans, screen clips) so that any text that appears in them is searchable.[71][75] Handwritten text on a tablet PC is also searchable.[75]
  • Words that are included in audio and video recordings are also tagged and indexed, so that they can be searched.[75]
  • Notes can have hyperlinks among themselves, or from outside OneNote to a specific point on a page.[71]
  • Embedding documents in notes.[71]
  • Extensibility support for add-ins.
  • Drawing tools for creating diagrams in OneNote.[71]
  • Typing any arithmetic expression, followed by "=" results in the result of the calculation being displayed.[71]
  • OneNote Import Printer Driver, where any application can print to a virtual printer for OneNote and the "printed" document is imported to the notebook; OCR is performed on the text that appears in the printed document to facilitate searches.[74][75]
  • OneNote Mobile is included for Smartphones and some PocketPC devices. Syncs notes two-way with OneNote. Takes text, voice, and photo notes.

Access[edit]

Main article: Microsoft Access

  • Access now includes support for a broader range of data types, including documents and images.
  • Whenever any table is updated, all reports referencing the table are also updated.
  • Dropdown lists for a table can be modified in place.
  • Lookup Fields, which get their values by "looking up" some value in a table, have been updated to support multi valued lookups.
  • Many new preset schemata are included.
  • Access can synchronize with Windows SharePoint Services 3.0 and Office SharePoint Server 2007. This feature enables a user to use Access reports while using a server-based, backed-up, IT managed version of the data.

Publisher[edit]

Main article: Microsoft Publisher

  • Templates automatically fill out with information such as company name, logo etc., wherever applicable.
  • Frequently used content can be stored in Content Store for quick access.
  • A document can be automatically converted from one publication type, such as a newsletter, to another publication type, say a web page.
  • Save as PDF supports commercial printing quality PDF.
  • Catalog Merge can create publication content automatically by retrieving data, including text, images and other supported types, from an external data source.
  • Design Checker, which is used to find design inconsistencies, has been updated.

InfoPath[edit]

Main article: Microsoft InfoPath

  • InfoPath designed forms can now be used from a browser, provided the server is running InfoPath Forms Services in SharePoint 2007 or Office Forms Server.
  • A form can be sent out to people via e-mail. Such forms can be filled out from Outlook 2007 itself.
  • Automatic conversion of forms in Word and Excel to InfoPath forms. Forms can also be exported to Excel.
  • Forms can be published to a network share or to SharePoint Server.
  • Adding data validation, using validation formulae, and conditional formatting features without manually writing code.
  • Print Layout view for designing forms in a view that mirror the printed layout. Such forms can be opened using Word as well.
  • Ability to use Microsoft SQL Server, Microsoft Office Access, or other databases as back-end data repository.
  • Multiple views for the same forms, to expose different features to different class of users.
  • Template Parts, used to group Office InfoPath controls for use later. Template parts retain its XML schema.

Visio[edit]

Main article: Microsoft Visio

  • PivotDiagrams, which are used to visualize data, show data groups and hierarchical relationships.[76]
    • Visual modification of PivotDiagrams by dragging data around levels, to restructure the data relationships.
    • PivotDiagrams can show aggregate statistical summaries for the data and show them.
  • Shapes can be linked with external data sources. Doing so, the shapes are formatted according to the data. The data, and hence the shapes, are updated periodically. Such shapes can also be formatted manually using the Data Graphics feature.
  • AutoConnect : Link easily two shapes.[77]
  • Data Link : Link data to shapes.[78]
  • Data Graphics : Dynamic objects (text and images) linked with external data.[79]
  • New Theme behaviour and new shapes.[80]

Project[edit]

Main article: Microsoft Project

  • Ability to create custom templates.
  • Any change in the project plan or schedule highlights everything else that is affected.
  • Analyze changes without actually committing them. Changes can also be done and undone programmatically, to automate analysis of different changes.
  • Improved cost resource management and analysis for projects.
  • Project data can be used to automatically create charts and diagrams in Microsoft Office Excel and Microsoft Office Visio, respectively.
  • The project schedule can be managed as 3D Gantt chart
  • Sharing project data with the help of SharePoint Services.

SharePoint Designer[edit]

Main article: Microsoft SharePoint Designer

Microsoft Office SharePoint Designer 2007 is new addition to the Office suite, replacing discontinued FrontPage for users of SharePoint. People who don't use SharePoint can use Microsoft Expression Web

  • Supports features and constructs that expose SharePoint functionality
  • Supports ASP.NET 2.0 and Windows Workflow Foundation
  • Support for creating workflows and data reports, from external data sources
  • Can optionally render XML using XSLT

Server components[edit]

SharePoint Server 2007[edit]

Main article: Microsoft Office SharePoint Server

Microsoft Office SharePoint Server 2007 allows sharing and collaborative editing of Office 2007 documents. It allows central storage of documents and management of Office documents, throughout the enterprise. These documents can be accessed either by the applications which created them, Microsoft Office Outlook 2007, or a web browser. Documents can also be managed through pre-defined policies that let users create and publish shared content, through a SharePoint site.

SharePoint Server allows searching of all Office documents which are being managed by it, centrally, thereby making data more accessible. It also provides access control for documents. Specialized server components can plug into the SharePoint Server to extend the functionality of the server, such as Excel Services exposing data analysis services for Excel services. Data from other data sources can also be merged with Office data.

SharePoint also lets users personalize the SharePoint sites, filtering content they are interested in. SharePoint documents can also be locally cached by clients for offline editing; the changes are later merged.

Forms Server 2007[edit]

Main article:

The ribbon in Microsoft PowerPoint 2007 running on Windows Vista

Microsoft Office 2010 (codenamed Office 14[7]) is a version of the Microsoft Officeproductivity suite for Microsoft Windows.[1] Office 2010 was released to manufacturing on April 15, 2010,[1] and was later made available for retail and online purchase on June 15, 2010.[8] It is the successor to Office 2007 and the predecessor to Office 2013. Research and development of Office 2010 began in 2006, before the release of its predecessor.[9]

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 apps and is fully customizable in Office 2010.[10][11][12] Other new features include extended file format support;[7]co-authoring features that enable multiple users to share and simultaneously edit documents;[13]OneDrive and SharePoint integration;[13] and security improvements such as Protected View, a read-only, isolated sandbox environment to protect users from potentially malicious content.[14] It also debuted Office Online—formerly Office Web Apps—a collection of free web-based versions of Excel, OneNote, PowerPoint, and Word.[15][16][17] Office Starter 2010, a new edition of Office, replaced Microsoft Works.[18][19][20]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.[21][22][23]

Office 2010 is the first version of Office to ship in two variants for IA-32 and x64,[24][25] but the x64 version is not compatible with Windows XP or Windows Server 2003.[26][27] It is also the first version to require product activation for volume license editions.[28][29] It is the last version of Office compatible with Windows XP, Windows Server 2003, Windows Vista and Windows Server 2008 as its successor, Office 2013, does not support these operating systems.[30][31][32][33]

Reception to Office 2010 was generally positive, with critics praising the new Backstage view interface, the new customization options for the ribbon, and the incorporation of the ribbon into all apps.[34][35] While sales were initially lower than those of its predecessor,[36] Office 2010 was a success for Microsoft and surpassed the company's previous records for adoption,[37] deployment,[37] and revenue.[38] As of December 31, 2011, approximately 200 million licenses of Office 2010 were sold,[39] before its discontinuation on January 31, 2013.[40] Mainstream support for Office 2010 ended on October 13, 2015; extended support will end on October 13, 2020.[3]

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.[9] It was previously thought that Office 2010 (then called Office 14) would ship in the first half of 2009.[41]

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.[42][43] The Technical Preview 1 (Version: 14.0.4006.1010) was leaked on May 15, 2009.[44]

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).[45] 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.[46] On August 30, 2009, the beta build 4417 was leaked on the internet via torrents.[47]

The public beta was available to subscribers of TechNet, MSDN and Microsoft Connect users on November 16, 2009.[48] 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.[49] Office 2010 Beta was a free, fully functional version and expired on October 31, 2010.[50]

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.[51] On February 5, 2010, the official release candidate build 4734.1000 was available to Connect and MSDN testers. It was leaked to torrent sites.[52] 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,[53] however it was made available to Business customers with Software Assurance on April 27, 2010, and to other Volume Licensing Customers on May 1.[54] 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.[55][56]

On June 15, 2010, Office 2010 reached general availability.[57][58]

Service packs[edit]

Service packVersion numberRelease date
Service Pack 1 (SP1)14.0.6029.1000[59]November 17, 2010[60]
Service Pack 2 (SP2)14.0.7015.1000[59]April 8, 2013[61]

Microsoft released a total of 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 such as Office Online, SharePoint, and SharePoint Designer.[60][61]

On November 17, 2010, Microsoft invited a select number of testers at the Microsoft Connect web portal to test the beta release of SP1.[62][63] SP1 was officially 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;[60][64] a list of exclusive fixes was released by Microsoft.[65] 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 Office 365 support.[64] With its release, the use of Office Online in Google Chrome and Internet Explorer 9 was officially supported by Microsoft for the first time.[66]

On April 8, 2013, a beta build of Office 2010 SP2 was released.[67] 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;[61] a list of fixes exclusive to SP2 was released by Microsoft.[68] Microsoft claimed that with the release of SP2, Office 2010 would feature improved compatibility with Internet Explorer 10, Office 2013, SharePoint 2013, and Windows 8.[61][69] Because SP2 is cumulative, SP1 is not a prerequisite for its installation.[70]

New features[edit]

User interface[edit]

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

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.[74] 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.[75] It 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.[74][76] A customizable number of recently opened documents can also be displayed within the navigation pane.[77]

Tasks that are accessed via tabs in the main pane are categorized into separate groups that display contextual information related to app configurations, files, and tasks; each tab displays contextual information relevant to that 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,[78] whereas the Help tab displays Office version information and product licensing status.[79] In Office 2007, this information was included within separate locations.[78][79] 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.[80] Within the Print tab, the Backstage view 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.[81]

The Backstage view, like the ribbon, is extensible; developers can add their own commands, tabs, tasks, and related information.[82][83][84]

File tab[edit]

The new 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 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.[77][85] Microsoft has stated that 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.[77] 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.[86]

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 after pressing + to display gallery options. Gallery options change based on the content in the clipboard and the app into which the content is pasted.[87]

Ribbon improvements[edit]

The ribbon interface, introduced in Office 2007, is fully customizable and included in all apps in Office 2010.[10][11] Users can add or rename custom ribbon tabs and 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.[88] The ribbon was also updated with a visible interface option to minimize it, which leaves only the tabs exposed.[89]

After the launch of Office 2010, Microsoft provided free downloads for customized ribbons with a new "Favorites" tab that consolidated various commands based on customer feedback in regards to the most frequently used commands in Office; the customized ribbons were available as separate downloads for Access, Excel, InfoPath, OneNote, Outlook, PowerPoint, Project, Publisher, Visio, and Word.[90]

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.[86]
  • All app icons have been redesigned in Office 2010. The new icons are based on colors that correspond to their respective apps, as per previous releases, with an increased emphasis on app letters.[86]
  • The Office 2010 splash screen has been redesigned from the one seen in Office 2007 and animates when an app is launched.[86]
  • OneNote and PowerPoint support mathematical equations through an Equation Tools contextual tab on the ribbon.[91][92]
  • PowerPoint and Publisher include alignment guides so users can align objects to a grid.[92][93]
  • Smart tags, introduced in Office XP, have been renamed as Actions and are now accessible from the context menu.[94]

File formats[edit]

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

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).[7]

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 documents stored in shared folders by OneDrive.[13] Office 365 is also supported.[97] A co-authoring session is automatically initiated when two or more users open the same document. From the Backstage view users can also save documents directly to remote locations within Excel, OneNote, PowerPoint, and Word to facilitate remote access and co-authoring sessions. A Microsoft account is required to use Office 2010 functionality related to OneDrive.[13] In the Excel Web App, the OneNote Web App, and OneNote, edits to a shared document in a co-authoring session occur on a sequential basis, and appear in near real-time as a shared document automatically saves itself each time a co-author edits it. In PowerPoint and Word, users must upload changes to the server by manually saving the shared document.[13]

During a co-authoring session, the Excel Web App, PowerPoint, and Word denote how many co-authors are editing a document at a given time through an icon on the status bar. Clicking this icon in PowerPoint and Word displays contact information including the presence of co-authors; similar information can be accessed through the Info tab of the Backstage view. When co-authors click the name of another co-author, they can send an e-mail message 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.[13]

In both the OneNote Web App and OneNote, 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 and the initials of the co-author who made an edit are automatically displayed. In the client version of OneNote, co-authors can also search for all edits to a notebook made by a specific co-author. OneNote 2010 notebooks can be shared with Office Mobile 2010 users on Windows Phone 7.[13] 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, the aforementioned co-author search and page versioning features, as well as compatibility with the OneNote Web App, will not be available.[98]

Installation and deployment[edit]

Office 2010 introduces a new Click-to-Run installation process based on Microsoft App-Vstreaming 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 apps themselves already been installed so that users can immediately begin using the apps. The download process is optimized for broadband connections.[99]

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—at a reduced cost when compared with traditional retail media—to activate Home and Student, Home and Business, and Professional editions preinstalled on personal computers.[100] Product Key Card versions are restricted to a single machine.[101]

Volume license versions of Office 2010 require product activation. In Office 2007 product activation was only required for OEM or retail versions of the product.[28]

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.[102] this design allows users to visually assess potentially unsafe documents that fail validation.[103] 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.[102] 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.[104]

On December 14, 2010, Microsoft announced its intent to backport the Office File Validation feature to Office 2003 and Office 2007.[105][106] On April 12, 2011, Office File Validation was backported as an add-in for Office 2003 SP3 and Office 2007 SP2, and was later made available through Microsoft Update on June 28, 2011.[107] 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.[107] Additionally, the configuration options in these two releases are only made available through the Windows Registry,[108] whereas Office 2010 also provides Group Policy options.[102]

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 a potentially unsafe location such as the Internet or as an e-mail attachment, or if a document does not comply with File Block policy or if it fails Office File Validation, it is opened in Protected View, which prohibits potentially unsafe documents from modifying components, files, and other resources on a system; users can also manually open documents in Protected View.[109] When a document is opened in Protected View, users are allowed to view, copy, and paste the contents of the document, but there are no options to edit, save, or print contents, and all active document content including ActiveX controls, database connections, hyperlinks, and macros is disabled.[110] Users can open documents outside of Protected View by clicking on the "Enable Editing" button that appears on a message bar within the Office user interface. As a precautionary measure, active content within a potentially unsafe document remains disabled when a user reopens it after exiting Protected View until a user clicks the "Enable Content" button on the message bar, which designates the document as a trusted document so that users are not prompted when it is opened in the future.[111]

Protected View is implemented as a separate child process instance of Excel, PowerPoint, and Word. The main process of each app is assigned the current user's access token and hosts the Office user interface elements such as the ribbon, whereas the Protected View process consists of the document viewing area, parses and renders the document content, and operates with reduced privileges; the main process serves as a mediator for requests initiated by the separate process. In Windows Vista and later versions of Windows, Mandatory Integrity Control and User Interface Privilege Isolation further restrict the separate process.[109] Protected View is also available when Office 2010 is installed on Windows XP, but it is not as robust due to the absence of these security features.[112]

Trusted documents[edit]

Office 2010 allows users to designate individual documents as trusted, which allows all active content to operate each time a specific document is opened; trusted documents do not open in Protected View. Documents residing in either local or remote directories can be trusted, but users are warned if an attempt is made to trust a document from a remote resource. To increase security, documents in Temporary Internet Files and the TEMP directory cannot be trusted. Trusted document preferences, referred to as trust records, are stored within the Windows Registry on a per-user basis; trust records contain the full path to trusted documents and other information to protect users from social engineering attacks.[111]

Other security features[edit]

  • Office 2010 is the first version of Office to natively support Data Execution Prevention (DEP).[14] Office 2010 apps comply with DEP policies defined by an administrator and provide an option to disable DEP within the interface or Group Policy.[113]
  • A new Office ActiveX kill bit provides options to configure ActiveX controls within Office 2010 without affecting the operation of these controls within Internet Explorer.[14]
  • Additional Group Policy settings for File Block functionality in Excel, PowerPoint, and Word.[14]
  • Cryptography improvements, including support for Cryptography API: Next Generation in Access, Excel, InfoPath, OneNote, PowerPoint, and Word; Suite B support; and integrity validation of encrypted files.[14]
  • Document time stamping of digital signatures.[14]
  • Domain-based password complexity and enforcement policies.[14]

Graphics[edit]

Artistic effects[edit]

Excel, Outlook, PowerPoint, and Word include a variety of artistic effects such as glass, paint stroke, pastel, and pencil sketch effects that users can apply to inserted images.[114]

Background removal[edit]

A new background removal feature based on Microsoft Research technology is included in Excel, Outlook, PowerPoint, and Word to remove the backgrounds of images inserted into documents. It is exposed as a Remove Background command that appears on the Picture Tools contextual tab on the ribbon when an image is selected. When activated this command displays a separate Background Removal contextual tab and places a selection rectangle and magenta color over portions of the selected image. The selection rectangle determines, based on an algorithm, which area of the selected image will be retained once the background removal process is complete, whereas the magenta color indicates the areas that will be removed. Users can manually adjust the position and size of the selection rectangle and also mark individual areas of an image to keep or remove;[115] it is also possible to delete a mark after an inadvertent selection or if it produces an undesired result. After the background has been removed, users can apply various visual effects to the result image or wrap text in a document around it; users can also crop the image since removing the background does not reduce its original size.[116]

Cropping improvements[edit]

Office 2010 introduces improvements to the image crop process in Excel, Outook, PowerPoint, Word. The crop selection rectangle now grays out the portions of an image to be removed during a crop process and displays the result area in color, instead of completely removing all portions of an image outside of the selection rectangle from view as in previous versions of Office; images can now be repositioned underneath the selection rectangle while it is active. A new Aspect Ratio option under the Crop command on the ribbon presents a drop-drop down menu with options for both landscape and portrait page orientations to customize the aspect ratio of the selection rectangle before users crop an image, which automatically resizes the selection rectangle when users start the crop process; users can manually resize the selection rectangle and simultaneously preserve its aspect ratio by resizing it from its corners while pressing the key.[117] The aforementioned cropping improvements are also available in Publisher.[118]

The Picture Shape command in previous versions of Office has been replaced with a new Crop to Shape command that allows users to resize and move the selected shape during the crop process. By default, Office 2010, like previous versions, automatically resizes images that are inserted into shapes, which can negatively affect their aspect ratio. To address this, images in shapes can now be cropped or resized after being inserted, and individual Fit and Fill options have been incorporated. The former option resizes the selected image so that the entire area of the crop selection rectangle or shape is filled, whereas the latter option resizes the image so that it is displayed within the selection rectangle or within a shape in its entirety; both options maintain the original aspect ratio of the selected image. Images inserted into SmartArt diagrams can also be cropped, resized, or repositioned.[117]

Font effects and enhancements[edit]

Excel, PowerPoint, and Word support text effects such as bevels, gradient fills, glows, reflections, and shadows. Publisher and Word support OpenType features such as kerning, ligatures, stylistic sets, and text figures with fonts such as Calibri, Cambria, Corbel, and Gabriola.[114]

Hardware acceleration[edit]

Office 2010 apps including Excel, PowerPoint, and Word support hardware accelerated graphics when installed on a machine with a DirectX 9.0c-compliant GPU that has at least 64 MB of videomemory. Excel supports hardware accelerated chart drawing, and PowerPoint supports hardware accelerated animations, transitions, and video playback and effects; slideshow elements are now rendered as sprites, which are then composited with additional effects such as fades and wipes implemented using Pixel Shader 2.0. All Office 2010 apps support Direct3D hardware accelerated SmartArt and WordArt object and text rendering.[119] Additionally, the background removal feature and image adjustments such as brightness and contrast are all accelerated when used on capable hardware.[120]

Screenshot capture[edit]

Excel, Outlook, PowerPoint, and Word allow users to immediately insert a screenshot of open app windows or a selection of content on the screen into documents without saving the image as a file. The functionality is exposed through a new Screenshot command on the Insert tab of the ribbon that, when clicked, presents individual options to capture either app windows or selections of content. The former option presents open windows as thumbnails in a gallery on the ribbon that insert a screenshot of the selected window into the active app, while the latter option minimizes the currently active app, dims the screen, and presents a selection rectangle for users to create a screenshot by holding the main mouse button, dragging the selection rectangle to a desired area of the screen, and then releasing the button to automatically insert the selection as an image into the document. Only windows that have not been minimized to the taskbar can be captured. After a screenshot has been inserted, various adjustments can be made.[121]

SmartArt improvements[edit]

SmartArt, a set of diagrams introduced in Office 2007 for Excel, Outlook, PowerPoint, and Word, has been updated with new effects, options, and interface improvements. The SmartArt text pane now allows users to insert, modify, and reorder images and their associated text within a diagram, and new Move Up and Move Down commands on the ribbon facilitate the reordering of content. Images are automatically cropped when inserted into shapes within SmartArt diagrams to preserve their aspect ratio; users can also manually reposition images. During the crop process, the layout of shapes in SmartArt diagrams is locked to prevent users from inadvertently modifying its position while making adjustments to an image.[117] Approximately 50 new diagrams have been introduced. Of these, a new Picture category dedicated to the presentation of images includes over 30 diagrams, and the Organization Chart category includes 3 new diagrams.[122]

A new Convert command on the SmartArt contextual tab on the ribbon includes additional features for Excel and PowerPoint. The Convert to Shapes command, a feature introduced in Office 2007 SP2 as a context menu option that turned SmartArt into a group of customizable shapes, is now featured as on option on the ribbon in both apps. Additionally, in PowerPoint, it is possible to convert SmartArt diagrams into bulleted lists through a new Convert to Text option.[122]

Accessibility[edit]

Accessibility Checker[edit]

Office 2010 introduces an Accessibility Checker feature in Excel, PowerPoint, and Word that inspects documents for issues that could negatively affect visually impaired readers. Accessibility Checker can be accessed through the "Check for Issues" button on the Prepare for Sharing group on the Info tab of the Backstage view. Clicking the button opens a task pane with a list of accessibility issues discovered in the document and also provides suggestions to address these issues. The Backstage view also reports accessibility issues in the Prepare for Sharing group so that they can be addressed before the document is shared with other users.[123] Administrators can configure how prominently this information is displayed within the interface through Group Policy.[124]

Language preferences[edit]

A Language Preferences interface in Access, Excel, OneNote, Outlook, PowerPoint, Project, Publisher, Visio, and Word is accessible in the Backstage view and replaces the language customization interface seen in previous versions of Office.[125] The new interface provides information about currently installed language packs and their related components, hyperlinks to download additional content, and a new ScreenTip Language feature that allows users to customize the language of tooltips.[126]

Text-to-speech improvements[edit]

A new Mini Translator feature allows users to translate selected text in OneNote, Outlook, PowerPoint, and Word. Translations for phrases or words are displayed within a tooltip, from which users can hear an audio pronunciation of the selected text provided by one of the Microsoft text-to-speech voices installed on a machine, copy the translation to the clipboard so that it can be inserted into another document, or view a definition provided by an online service if the selected text is a word.[127] The audio pronunciations are made available through a Speak feature, which can be accessed separately from the Mini Translator (e.g., added to the ribbon), but it can only be activated if a text-to-speech engine that matches the language of the selected text is installed. Users can download various text-to-speech engines from Microsoft.[128] The Speak feature is not available when Office 2010 is installed on Windows XP.[129]

New app-specific features[edit]

New features in Word 2010
  • A new navigation pane replaces the document map in previous versions of Word and allows users to drag and drop headings within the pane to rearrange pages in a document. The navigation pane also replaces the Find dialog box in previous versions and now highlights search results.[130]
  • Windows Live Writer integration.[10]
New features in Excel 2010
  • Excel 2010 includes a redesigned calculation engine to improve performance in response to feedback from users related to previous versions of Excel.[119] As part of the new calculation engine, a new version of the Solver add-in and new versions of statistical functions were introduced.[131]
  • Graphing features including Sparklines, miniature graphics that represent trends among data; and Slicers, which allow users to quickly filter data results.[131]
  • Macro recording support for chart elements.[131]
  • Rule-based cell formatting.[131]
  • The number of data points in a data series is limited only by available memory; in Excel 2007, there was a limitation of 32,000 data points.[131]
New features in PowerPoint 2010
  • A new Reading View allows users to display and progress through presentations in a window.[92]
  • An Animation Painter allows users to select and copy an animation and apply it to another slide.[92]
  • Audio editing and playback functionality allows users to fade, bookmark, or trim audio.[92]
  • Presentation sections allow users to visually customize the organization of slides in a presentation.[92]
  • Support for custom shapes.[92]
  • The ability to remotely broadcast a slide show ("Broadcast Slide Show") with the use of a Microsoft account; local broadcasts through SharePoint are supported.[92]
  • Users can simulate a laser pointer with a mouse cursor by holding down the key and pressing the primary mouse button during a presentation.[92]
  • Video editing and playback functionality; local videos are now embedded within slides by default so that they can be played regardless of whether users have access to their original source. Options include the ability to add various visual effects, to bookmark specific scenes for playback when advancing slides, to fade in or out, and to trim videos. Online videos can also be inserted into presentations, and presentations themselves can be saved as videos.[92]
New features in OneNote 2010
  • A native x64 printer driver for x64 operating systems.[132]
  • A new docked mode enables OneNote to be displayed alongside next to another app window while taking notes.[91]
  • A notebook recycle bin, which stores for 60 days any notebooks, pages, sections, and section groups that were previously deleted.[91]
  • A Quick Filing feature allows users to choose which location in a notebook to quickly send information to from within other apps.[132]
  • Linked Notes reference specific sections of a source document or web page so that clicking a note that was taken while the source was open will automatically return users to that content;[132]Internet Explorer 6 and later versions, PowerPoint 2010, and Word 2010 support Linked Notes.[91]
  • Incremental search has been incorporated and future search results are prioritized based on previous search queries.[91]
  • Multi-touch pan and pinch gestures when installed on a multi-touch capable operating system such as Windows 7.[132]
  • Outlook tasks can be created directly from OneNote.[132]
  • Page versioning, which allows multiple versions of a single page to exist in a notebook.[91]
  • Sections can be copied or merged.[91]
  • Style galleries, similar to those in Word, have been included in OneNote to provide basic formatting options.[91]
  • Support for automatic text wrapping.[132]
  • XPS documents protected by information rights management can be inserted as printouts.[132]
  • The ability to sync notebooks with a Microsoft account;[132] SP1 introduced the ability to open notebooks from OneDrive.[64]
  • The Format Painter in Word is available in OneNote.[91]
  • Wiki-style bracket syntax can be used to link to pages, sections, and section groups from other locations in a notebook.[91]
New features in Outlook 2010
  • A new Search Tools contextual tab is displayed on the ribbon when users perform a search and provides commands to filter results based on different criterion.[133]
  • A Social Connector aggregates content from users' social network contacts and displays related information such as activity feeds, appointments, communication history, and file attachments.[133]
  • An improved Conversation View groups messages by their subjects regardless of their originating folders. Additionally, a new Ignore command deletes all messages in a conversation and sends all future replies to the Deleted Items folder, while a new Clean Up command deletes all messages but the most recent.[133]
  • Quick Steps, individual collections of commands that allow users to perform multiple actions simultaneously. Users can create their own Quick Steps and optionally assign keyboard shortcuts or customize tooltips for each of them.[134]
  • Spell check
The Info tab on the navigation pane of the Backstage view displaying an overview of the current document alongside management tasks in Word 2010.