User's Manual

164
• Worksheet names: In a cell in a worksheet, names that reference worksheets within the same
workbook are displayed accurately. Names that refer to other workbooks, arrays such as ={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?” Tabs that
are hidden in the workbook are not hidden in Excel Mobile.
•
AutoFilter settings: These 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 le 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
modied 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 placeholder sheet; text boxes,
drawing objects, pictures, lists, conditional formats, and controls are removed; pivot table is converted
to values.
•
Excel 2007 Binary (.xlsb) workbooks: Not supported.
•
File conversions:
• . xls/.xlt les cannot be saved as .xlsx/.xltx les, and .xlsx/.xltx les cannot be saved as .xls/.xlt
les
• rights-managed and password-protected les can be saved only in their original format.
•
Mandatory default le conversions upon saving: .xlsm/.xltm to .xlsx/.xltx; and .pxl/.pxt to .xls/.xlt