i-mate JAMA 101, User Manual

Page: 127 / 152

formulas containing external link references or an intersection range
reference; and formulas containing references past row 16384 are
replaced with #REF!
• 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
127
i-mate
™