Section 9: Using Other ApplicationsSection 9: Using Other Applications
149
Section 9: Using Other ApplicationsSection 9: Using Other Applications
Protection settings. Most worksheet and workbook protection
features are disabled but not removed. However, support
for password protection has been removed. Workbooks that
are password-protected or workbooks in which one or more
worksheets are password-protected cannot be opened. You
must remove the password protection in Excel on the PC and
then synchronize to open the file on the device.
Zoom settings. Are not retained. Excel supports a per
worksheet zoom setting, while the Excel Mobile zoom setting
is applied to the entire workbook.
Worksheet names. Names that reference worksheets within
the same workbook are displayed accurately, but names that
refer to other workbooks, arrays, for example, ={1;2;3;4}, array
formulas, or intersection ranges are removed from the name
list. If a name is removed from the list, it is left in formulas and
functions, causing those formulas to be resolved as “#NAME?”
All hidden names are not hidden.
AutoFilter settings. Are removed. However, you can use the
AutoFilter command in Excel Mobile to perform similar
functions. If you have an AutoFilter applied to a worksheet
that causes rows to be hidden, the rows remain hidden when
the file is opened in Excel Mobile. Use the Unhide command to
display the hidden rows
Chart formatting. All charts will be saved the way they are
shown 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.
Worksheet features. The following features are not supported
in Excel Mobile and are removed or modified when a workbook
is opened on the device: hidden sheets are not hidden; VBA
modules, macro sheets, and dialog sheets are removed and
replaced with a place holder sheet; text boxes, drawing
objects, pictures, lists, conditional formats, and controls are
removed; pivot table data is converted to values.
To get more help about Excel Mobile:
When in Excel Mobile, tap Start > Help.