Discontinued features and modified functionality in Excel 2010

The following features have been discontinued or significantly changed in Excel 2010.

In this article


Conditional Sum Wizard add-in

This add-in is no longer included with Excel 2010. In earlier versions of Excel, you could use the Conditional Sum Wizard to help you write formulas that calculate the sums of values that met specified conditions. In Excel 2010, you can write conditional formulas by using functions that are designed to help with that task, such as the SUMIF and SUMIFS functions.

Formulas that were generated by this wizard will continue to work in Excel 2010. You can edit them by using other methods.

Top of Page Top of Page

Lookup Wizard add-in

This add-in is no longer included with Excel 2010. In earlier versions of Excel, you could use the Lookup Wizard to help you write formulas that would find a value at the intersection of a row and column by looking up values. This functionality has been replaced by the function wizard and the available Lookup and reference functions (reference).

Formulas that were generated by this wizard will continue to work in Excel 2010. You can edit them by using other methods.

Top of Page Top of Page

Smart tags

Smart tags are not supported in Excel 2010. Smart tag indicators (such as the purple triangles in the corners of cells) are no longer displayed in the worksheet when you select a cell or move the pointer over the cell. Instead, you can right-click a cell to view any custom actions associated with its contents by clicking Additional actions on the shortcut menu.

Additional actions are disabled by default, but you can enable or disable this functionality on the Actions tab of the AutoCorrect dialog box (File tab, Options, Proofing category, AutoCorrect Options button).

Top of Page Top of Page

SmartArt

Pattern fills

The pattern fills interface for shape objects, such as chart elements, was not provided with the new SmartArt technology in Excel 2007, causing display issues when pattern fills were used in earlier versions of Excel. In Excel 2010, SmartArt provides the pattern fills interface so that you can apply a pattern fill to shape objects. Shape objects that contain pattern fills in Excel 97-2003 workbooks will also be displayed correctly when those workbooks are opened in Excel 2010.

Controls and objects

In Excel 2010, in addition to shape objects, the following controls and objects are converted to the new SmartArt technology:

  • Form controls
  • Microsoft ActiveX objects
  • OLE objects
  • Camera tool objects

It is important to note that shape objects drawn in earlier versions of Excel that are not upgraded to Excel 2010 SmartArt format cannot be grouped with shape objects that are created in or upgraded to Excel 2010 SmartArt format. Mixed shape objects will be layered, with the earlier versions of shape objects drawn on top of all later versions. This also means that Excel 2010 charts cannot be shown on dialog sheets that were created in an earlier version of Excel. You won’t be able to access the new shape objects by clicking Select Objects (Home tab, Editing group, Find & Select button). To select the newer shape objects, you must use the Select Multiple Objects command (File tab, Options, Customize Ribbon).

Top of Page Top of Page

Clip Art task pane

Search in box

The Search in box is no longer available, which means that you can no longer limit your search to specific collections of content. To narrow your search, you can use multiple search terms in the Search for box.

Organize clips link

The Organize clips link is no longer available. To open Microsoft Clip Organizer from Windows 7, Windows Vista, or Windows XP, click the Windows Start button, click All Programs, click Microsoft Office, click Microsoft Office 2010 Tools, and then click Microsoft Clip Organizer.

Top of Page Top of Page

Clip Organizer

Clip Organizer is a tool that arranges and catalogs clip art and other media files stored on your hard disk. As described earlier in this article, Clip Organizer is no longer accessible directly the Clip Art task pane in Microsoft Office programs. In addition, the following changes were made to Clip Organizer:

Automatic organization

The command for automatically finding media files on your computer and organizing them into collections no longer exists. However, you can still add clips manually to Clip Organizer or import them from a scanner or camera.

Send to e-mail recipient as attachment

The command for sending a clip as an attachment in e-mail messages is no longer available.

Delete from collection

Although you can delete clips from Clip Organizer, you can no longer delete a clip from a specific collection.

Find similar style

The command that allowed you to find clips of a similar style is no longer available.

List and Details views

The List and Details views are no longer available. Instead, all clips appear as thumbnails in the Clip Organizer window.

Top of Page Top of Page

 
 
Applies to:
Excel 2010