User Guide

STAYING PRODUCTIVE
EXCEL MOBILE
145
7
CHAPTER
• 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.