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).

Productivity

Section 5B: Increasing Your Productivity

293

Page 293
Image 293
Palm TREOPROBLKSPT manual Increasing Your Productivity 293