![](/images/backgrounds/221580/bg125.png)
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 setting s: 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, 3Deffects,
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 TreoPro 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).