Office 2010 - Changes in Microsoft Excel 2010

This article lists changes in Microsoft Excel 2010 since the release of Microsoft Office Excel 2007 and in view of migration considerations. If you are upgrading from Microsoft Office Excel 2003, see also Changes in Excel 2007 and Migration considerations for Excel 2007.

Office 2010 Logo

Changes in Microsoft Excel 2010 - What’s new

This section highlights new features in Excel 2010 that might be of interest to IT administrators.

Support for high performance computing

  • Excel 2010 includes options for integrating with compute clusters, such as Windows HPC Server 2008. This option is not supported for 32-bit and ia64-based, language-specific, Itanium platforms. Excel 2010 can offload the processing of cluster-safe user-defined functions (UDFs) in XLL add-ins to a compute cluster when they are called from an Excel workbook. When a supported computer cluster is available, users can instruct Excel to use that cluster by selecting a cluster connector and configuring a specific cluster name to use in the Advanced options of the Excel Options dialog box.

Microsoft SQL Server PowerPivot for Excel add-in

  • If you need to model and analyze very large amounts of data, you can download the PowerPivot for Excel add-in and work with that data inside your Excel workbooks. By using this add-in, you can quickly combine data from multiple sources, including corporate databases, worksheets, reports, and data feeds. You can then interactively explore, calculate, and summarize that data by using PivotTables, slicers, and other Excel features. As you interact with the data, you will notice that the response time is fast, whether you are working with hundreds of rows, or hundreds of millions of rows.If you have access to Excel Services in Microsoft SharePoint Server 2010, you can make your reports and analyses available on a SharePoint site so that other people in your organization can benefit from your work.

New version of Solver

  • Excel 2010 includes a new version of the Solver add-in, which you can use to find optimal solutions in what-if analysis. Solver has an improved user interface, a new Evolutionary Solver, based on genetic algorithms, that handles models with any Excel functions, new global optimization options, better linear programming and nonlinear optimization methods, and new linearity and feasibility reports. In addition, the Solver add-in is now available in a 64-bit version.

Changes in Microsoft Excel 2010 - What’s changed

This section summarizes the feature changes in Excel 2010 that might be of interest to IT administrators. For more information about changed features, see Microsoft Excel 2010.

PivotTable enhancements

PivotTables are easier and faster to use in Excel 2010. Some of the key improvements include the following:

  • Improved performance - In Excel 2010, multithreading helps speed up data retrieval, sorting, and filtering in PivotTables.
  • Write-back support - In Excel 2010, you can change values in the OLAP PivotTable Values area and have them written back to the Analysis Services cube on the OLAP server.

Excel Services enhancements

Many organizations use Excel Services to share workbooks and data with other people, such as executives and other stakeholders in your organization. If you use Excel Services to save or publish workbooks to a SharePoint site, you can take advantage of the following improvements:
  • Share workbooks from Backstage view   Although it was previously possible to save and publish worksheet data to a SharePoint site, in Excel 2010, the options for doing this are now conveniently located together on the Share tab in the Microsoft Office Backstage.
  • More support for Excel features   Previously, if a workbook contained unsupported features, it could not be opened in the browser. In this release, most workbooks with unsupported features will open. In addition, more Excel features are supported in Excel Services, including new Excel 2010 features such as sparklines and slicers.

Charting enhancements

It is easier to work with charts in Excel 2010. Specific improvements include the following:
  • New charting limits - In Microsoft Office Excel 2007, you could have up to 32,000 data points in a data series for 2-D charts. In Excel 2010, the number of data points in a data series is limited only by available memory. This enables users especially those in the scientific community to more effectively visualize and analyze large sets of data.
  • Macro recording for chart elements - In Office Excel 2007, recording a macro while formatting a chart or other object did not produce any macro code. However, in Excel 2010, you can use the macro recorder to record formatting changes to charts and other objects.

Smart tags now “Additional actions”

  • Smart tags have been replaced by the context menu option “Additional actions” in Excel 2010. Text is no longer automatically recognized by a smart tag recognizer and is no longer marked by a purple dotted underline of the activated cell. Instead, users are able to trigger the data recognition function and view the custom actions associated with text by selecting the text and choosing the Additional actions item on the context menu activated by right-clicking a selected cell.

Changes in Microsoft Excel 2010 - What’s removed

This section highlights features that were available in previous versions of Microsoft Office that are removed from Excel 2010 and that might be of interest to IT administrators.

Conditional Sum Wizard

  • This add-in is no longer available in Excel 2010. Instead, write formulas that calculate the sums of values that meet specified conditions

Lookup Wizard

  • This add-in is no longer available in Excel 2010. Instead, users can write a formula that finds the value at the intersection of a column and a row.

Calendar Control

  • Calendar control (mscal.ocx) was a Microsoft Access feature that could be used in Access worksheets. Calendar control is removed in Access 2010 and is not usable for Excel 2010. Instead, users can use Date Picker or their own custom calendar controls.

MSXML5

  • MSXML5 is not supported in Excel 2010. Users will receive a runtime error if they attempt to run an Excel extensibility solution created by using MSXML5. Migrate code to MSXML6 or to managed code that uses the .NET Framework.

Changes in Microsoft Excel 2010 - Migration considerations

  • When planning a migration to Excel 2010, review what is new, changed, and removed for Excel 2010. Because Excel 2010 has many similarities with Office Excel 2007, such as the same native file format, you can also review and use the existing migration documentation for Office Excel 2007 when you migrate to Excel 2010.

Office 2010 - Microsoft Office 2010 Überblick

Mit Microsoft Office 2010 verfügen Sie über vielfältige und leistungsfähige neue Methoden, Ihr Bestes zu tun – im Beruf, zu Hause oder in der Schule, auf Ihrem Computer, auf einem auf Windows Mobile basierenden Smartphone oder mit einem Webbrowser.

Office 2010 - Microsoft Office 2010 Overview

Microsoft® Office 2010 offers flexible and powerful new ways to deliver your best work - at the office, at home or at school. Stay connected to your projects, even when you’re away from your computer, with access to Office files via Web browser or smartphone.