User's Manual
163
Excel
®
Mobile
Excel workbooks created on a computer can be opened and edited on your device. However, Excel Mobile
does not fully support some features, such as formulas and cell comments.
Unsupported features
• Alignment: Horizontal, vertical, and wrap text attributes remain the same, but vertical text appears
horizontal.
•
Borders: Appear as a single line.
•
Cell patterns: Patterns applied to cells are removed.
•
Fonts and font sizes: Fonts not supported by your device are mapped to the closest font available.
The original font is listed on your device. When the workbook is opened again in Excel on your
computer, the data are displayed in the original font.
•
Number formats: Numbers formatted using the Microsoft
®
Excel 97 conditional formatting feature
are displayed in Number format.
•
Formulas and functions: Formulas containing references past row 16384 are replaced with #REF!
Also, the following formulas are converted to values:
• formulas containing functions not supported by Excel Mobile
• formulas entered as an array or containing an array argument. For example,
= SUM({1;2;3;4})
• formulas containing external link references or intersection range reference
•
Protection settings: If a password to open has been specied for a workbook, it can be opened in
Excel Mobile but cannot be modied.
•
Zoom settings: These are not retained. Excel supports a per worksheet zoom setting, while the
Excel Mobile zoom setting is applied to the whole workbook.