|
When opening a workbook in Microsoft Office Excel 2007 that was created in an earlier version of Microsoft Office Excel (97-2003), some features of the earlier version of Excel are not supported in the workbook. Unsupported features have either been replaced by new features and functionality, or they have been removed.
Tip: If features are not available in the Microsoft Office Fluent user interface but are still available in Office Excel 2007, you can still use those features by adding them to the Quick Access Toolbar.
The following Excel 97-2003 features may function differently, have been removed, or are not available on the Ribbon (part of the Office Fluent user interface) in Office Excel 2007.
|
|
Excel ’97-2003
|
Excel 2007
|
|
Unsupported worksheet features:
|
Autoformat
|
Changed to Style Galleries
|
|
Unsupported table features:
|
Excel list
Insert row
Defined Names
Synchronizing Excel tables w/share Points
|
Changed to Excel Tables
Press Tab or Type/Paste data just below the tab
Are now created when table is created
May not meet new requirements
|
|
Unsupported formula and function features:
|
Full row and full column references
Ex. A:A refers to cell A1:A65536
Defined names in formulas
|
New feature takes in account the larger grid size
Ex. A:A refers to cell A1:A1048576
Earlier version conflicts with valid cell references. You will be alerted about incompatible names
|
|
Unsupported charting features:
|
Simultaneous resizing of multiple charts
Duplicate Chart sheets that contain data
Changing the rotation of 3-D charts
Using pattern fills in chart elements
Sizing charts with the windows
Automatically creating a text box
Copying charts to Microsoft Word and Powerpoint 2007
Using a Word table as a data source
Printed chart size
Drag and drop data
Direct manipulation of data points on charts
Grouping and selecting shapes
|
You can no longer size multiple charts simultaneously you must resize each individually
You can no longer duplicate charts sheets that contain data by pressing F11. F11 creates a new chart sheet without data
You can only change the rotation of a 3-D chart by specifying settings in the 3-D rotation category in the Format Chart Area dialog box
Instead of pattern fills in chart elements, you can use picture and texture fills
Instead of Size with Window, you can use the Zoom to Selection command
You cannot create a text box when you click anywhere on the chart and start typing. To add a text box use the when you type on a chart Insert Text Box command
A copied chart is pasted in a Word or Powerpoint document as an object and is linked to the Excel chart
A table in Word 2007 cannot be used as data for a new chart
The printed chart size and scaling options are no longer available on the Chart tab. The chart tab is only available when a chart is selected
You can no longer drag and drop data from a worksheet to a chart
Dragging data points to change the source values on the worksheet is no longer supported
Shapes that are drawn in earlier versions of Excel cannot be grouped with shapes that are drawn in Excel 2007, even when the shaped are upgrades to the current version
|
|
Unsupported PivotTable features:
|
Defined names
Calculated members
Filtering with SQL Server 2005 Analysis Services
OLAP Cube Wizard
PivotTable and PivotChart Wizard
Custom labels and item formatting
|
Names used in earlier versions of Excel many not meet the requirements for range names in Excel 2007 and therefore cannot be used for referencing a table in formulas. To use PivotTable names in structured references, you must change the defined names
Calculated members that are defined in OLAP cubes are no longer displayed by default but calculated measures are. You can display calculated members by selecting Show calculated members from OLAP server on the Display tab
The new filtering options in OLAP PivotTable require support for subselects on the OLAP server
The OLAP Cube Wizard is no longer available.
The PivotTable and PivotChart Wizard are not available on the Office Fluent Ribbon.To create PivotTables that are based on relational data, you can connect to the relational data directly, or you can import the relational data into an Excel workbook Use the Insert PivotTable or PivotChart commands
PivotTables preserve customization items even when those items are temporarily not visible in the PivotTable
|
|
Unsupported developer features:
|
Microsoft Script Editor
|
Integration with Microsoft Editor has been removed from the 2007 office system, which means script debugging components are no longer available in Excel 2007. However the script editor is still installed with 2007 office so you can use the editor as a standalone program to edit HTML files
|
Unsupported file formats:
Support for the following file formats has been removed from Excel 2007. You will not be able to open or save workbooks in the file formats.
WK1, ALL(1-2-3)
WK4 (1-2-3)
WJ1 (1-2-3 Japanese) (*.wj1)
WJ3 (1-2-3 Japanese) (*.wj3)
WKS (1-2-3)
WKS (Works Japanese) (*wks)
WK3, FM3(1-2-3)
WK1, FMT(1-2-3)
WJ2 (1-2-3 Japanese) (*.wj2)
WJ3, FJ3 (1-2-3 Japanese) (*.wj3)
DBF 2 (dBASE II)
WQ1 (Quattro Pro/DOS)
Microsoft Excel Chart (*.xlc)
Support for the following file formats has changed.
|
File format
|
Excel 2007
|
|
Web Page (*.htm; *.html)
|
Excel 2007 no longer stores Excel-specific feature information in this file format. You can open a file in this format, preserving any Excel-specific features that were created in an earlier version of Excel. However, you can save such a file (or any other workbook) in this file format for publishing purposes only
|
|
Single File Web Page (*.mht; *.mhtml)
|
Excel 2007 no longer stores Excel-specific feature information in this file format. You can open a file in this format, preserving any Excel-specific features that were created in an earlier version of Excel. However, you can save such a file (or any other workbook) in this file format for publishing purposes only
|
Information sourced from Microsoft.com
5000
6/15/2009 12:28:22 PM
|
