Palm 1065NA User Guide - Page 248
Formulas and functions, Protection settings, Zoom settings, Worksheet names, AutoFilter Settings
UPC - 805931035639
View all Palm 1065NA manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 248 highlights
11 Y O U R M I C R O S O F T O F F I C E A N D O T H E R D O C U M E N T T O O L S CHAPTER Formulas and functions: Unsupported functions are removed, and only the returned value of the function appears. Formulas containing the following are also converted to values: • An array or array argument, for example, =SUM({1;2;3;4}). • External link references or an intersection range reference. • References past row 16384 are replaced with #REF!. 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 (converted to values) 248 E X C E L M O B I L E ®