Palm 700wx User Manual

Page 153

Advertising
background image

S T A Y I N G P R O D U C T I V E

E X C E L M O B I L E

145

7

CH

AP

T

E

R

Protection settings: Most protection
features are disabled but not removed.
However, password protection is
removed. You must remove the
password protection in Microsoft

®

Office Excel

®

on your computer before

opening the file on your smartphone.

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, gridlines, data
labels, trend lines, shadows, 3D effects,
secondary axes, and logarithmic scales
are turned off.

The following features aren’t supported in
Excel Mobile and are removed or modified
when you open a workbook on your
smartphone:

Hidden, dialog, and macro sheets

VBA modules

Text boxes

Drawing objects and pictures

Lists

Conditional formats and controls

Pivot table data (is converted to values)

TIP

For simple calculations, use the Calculator

(see Calculator).

TIP

To copy a file from your computer to your

smartphone, open My Computer or Windows
Explorer on your computer, copy the file into
the Mobile Device folder, and then sync.

Advertising