Article ID: 179824
Article Last Modified on 1/22/2007
Excel format or feature Conversion to Excel 5.0 or 7.0 ------------------------------------------------------------------------ 65,536 rows per worksheet Rows after 16,384 are deleted. 32,000 characters per cell Characters after 255 are deleted. Custom views defined for a Not saved. workbook Attached toolbars Not saved.
Excel format or feature Conversion to Excel 5.0 or 7.0
------------------------------------------------------------------------
Text formatted with Shrink To Text is converted to the original point
Fit (on the Alignment size (before Shrink To Fit was applied).
tab of the Cells dialog box)
Rotated text Text that is rotated at angles other
than 90 degrees, -90 degrees, or 0
(zero) degrees, is changed to the
horizontal orientation.
Indentations within cells Indentation is removed, and the contents
of cells are left-aligned.
Merged cells Merged cells are split into their
original configurations. Data is placed
in the upper-left cell.
Conditional formatting Conditional formatting is lost, and
cells are reformatted with the Normal
style.
Sheet backgrounds Not saved.
New border styles Border styles are converted to the
most closely matched border style
available in Microsoft Excel
7.0 or 5.0.
Excel format or feature Conversion to Excel 5.0 or 7.0
----------------------------------------------------------------------
Pie-of-pie or bar-of-pie Saved as first type pie chart.
chart format
Bubble chart Saved as first type xy (scatter) chart.
3-D marker shape (cylinder, Saved as 3-D column chart (rectangular
pyramid, and cone charts) shape).
Data tables in charts Not saved.
Rotated text on axis and Saved as horizontally oriented text
data labels (0 [zero] degrees).
Gradient fills and patterns Saved as the most closely matched
on chart items available solid color and pattern.
Shading in surface charts Shading is not saved.
Time-scale axis (x-axis Special scaling information is lost,
categories with date format) and the axis is converted to a normal
category axis.
Shadows on series and points Not saved.
Sizable line and xy (scatter) Not saved.
data markers
Special placement of data Saved in the default location for chart
labels items.
Excel format or feature Conversion to Excel 5.0 or 7.0
-------------------------------------------------------------------
Natural language references Column and row label references are
in formulas converted to A1 reference notation.
Names of named cells and ranges are
preserved.
These New worksheet functions: Not supported in Microsoft Excel 7.0 or
AVERAGEA; MAXA; MINA; 5.0. Microsoft Excel calculates the
STDEVA; STDEVPA; VARA; VARPA; function before saving the file and
HYPERLINK; GETPIVOTDATA replaces the formula with the resulting
value. The HYPERLINK function is
converted to =#N/A.
Calculated fields, calculated These PivotTable features are preserved
items, and formatting based until you change or refresh the
on structured data tables PivotTable data, after which the
features are lost.
Preserved formatting in Formatting is saved, but structured
PivotTables behavior is lost as soon you make
any changes to or refresh the PivotTable
data.
PivotTable properties sheet All properties that are new in Microsoft
Excel 2000/2002 are lost, including the
following:
- Page field placement across columns
or down rows
- Alternate strings for #N/A and errors
displayed in cells
- Server-based page fields
- AutoSort and AutoShow on fields
- Multiple selection on page fields
- Persistent grouping and sorting
- Data fields displayed as numbers
Web and database queries to Data resulting from the latest query
external data sources is saved, but the query is not saved.
Parameterized queries Parameterized queries cannot be executed
or edited.
Shared queries (connections Files that contain connections without
without a data source name) a data source name are supported in
Microsoft Excel 7.0 (with ODBC 2.0).
In Microsoft Excel 5.0 (with ODBC 1.0),
you are prompted for connection
information.
Report templates Not saved.
Scenarios Scenarios defined for each sheet are
saved.
Excel format or feature Conversion to Excel 5.0 or 7.0
-------------------------------------------------------------------
Map objects Saved.
WordArt objects Saved as a filled rectangle.
AutoShape drawing objects Converted to Microsoft Excel 5.0 or 7.0
drawing objects; three-dimensional
shapes are preserved as two-dimensional
objects.
Organization chart objects Saved.
Scanned photographic images Images that are inserted in a graphics
format that is available in Microsoft
Excel 7.0 or 5.0 are saved.
Excel format or feature Conversion to Excel 5.0 or 7.0
-------------------------------------------------------------------
Comments Saved as cell notes.
Hyperlinks Not saved.
Change tracking and audit Change history is lost.
trail
Shared workbooks Workbook is removed from shared use, and
the change history is lost.
Data validation rules Not saved.
for cells
Excel format or feature Conversion to Excel 5.0 or 7.0
-------------------------------------------------------------------
ActiveX Controls ActiveX Controls appear in the workbook
but cannot be used.
Office Forms dialog box Not supported.
controls
Additional query words: XL9 XL2000
Keywords: kbhowto kbusage KB179824