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.
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.
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).
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).
Clip Art
Clip art comes from Bing Images
When you search for clip art and pictures online, you'll be directed to Bing. You're responsible for respecting copyright, and the license filter in Bing can help you choose which images to use.
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.
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.
English Assistance service is gone
Because of low usage, the English Assistance feature and service is no longer available. For more information, please see What happened to English Assistance?
If you try to use the service, you'll get the message "The service could not be searched because you are not connected to the Internet. Please connect and try again." even if you're connected to the Internet.
Korean Language Reference (KOLR) service is gone
Because of low usage, the Korean Language Reference research service is no longer available. This affects the English and Korean versions of Excel.
If you try to use the service, you'll get the message "The service could not be searched because you are not connected to the Internet. Please connect and try again." even if you're connected to the Internet.
No comments:
Post a Comment