Filter
Top Products
Section 5B: Increasing Your Productivity 293
Productivity
ⅷ Protection settings: Most protection features are disabled but are not removed. You must
remove the password protection in Microsoft
®
Office Excel
®
on your computer before
editing the file on your smartphone. Rights-managed and password-protected files must
be saved only in their original file format.
ⅷ Zoom settings: Worksheet-specific zoom settings are not retained. The zoom setting
applies to the entire workbook.
ⅷ Worksheet names: Names that refer to other workbooks, arrays, array formulas, or
intersection ranges are removed from the name list, causing those formulas to be
resolved as “#NAME?” All hidden names are not hidden.
ⅷ AutoFilter Settings: AutoFilters that cause rows to be hidden are supported. Use the
Unhide command to display hidden rows. Other AutoFilters are removed, but you can use
the AutoFilter command in Excel Mobile to perform similar functions.
ⅷ Chart Formatting: All charts are saved as they appear in Excel Mobile. Unsupported chart
types are changed to one of these supported types: Column, Bar, Line, Pie, Scatter, and
Area. Background colors, grid lines, data labels, trend lines, shadows, 3D effects,
secondary axes, and logarithmic scales are turned off.
ⅷ Hidden sheets. Hidden worksheets are displayed.
ⅷ Excel 2007 Binary workbooks. You cannot open XLSB workbooks.
ⅷ Legacy files. PXL and PXT files can be opened, but must be saved in XLS or XLT format.
ⅷ File conversions. You cannot save a file with an XLS or XLT extension as an XLSX or XLTX
file, respectively, and vice versa.
The following features are not supported in Excel Mobile and are removed or modified when
you open a workbook on your Treo Pro smartphone:
ⅷ Dialog sheets and macro sheets.
ⅷ VBA modules.
ⅷ Text boxes.
ⅷ Drawing objects and pictures.
ⅷ Lists.
ⅷ Conditional formats and controls.
ⅷ Pivot table data (is converted to values).