Filter
Top Products
10-117
Protection settings
. Most worksheet and workbook protection features
are disabled but not removed during conversion. Workbooks that are
password protected cannot be synchronized. You must remove the
password protection in Excel or Pocket Excel and then synchronize. Once
synchronized, you can reset password protection.
Zoom settings
. Not retained during conversion. Excel supports a per
worksheet zoom setting, while Pocket Excel's 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 unhidden.
AutoFilter Settings
. Are removed. However, you can use the
AutoFilter
command in Pocket Excel to perform similar functions. If you have an
AutoFilter applied to a worksheet that causes rows to be hidden, the rows
remain hidden after converting the file to Pocket Excel. Use the
Unhide
command to display the hidden rows.
Unsupported worksheet features
. The following features aren't
supported in Pocket Excel and are removed or modified during conversion:
chart objects are removed; hidden sheets are unhidden; chart sheets, VBA
modules, macro sheets, and dialog sheets are removed and replaced with
a place holder sheet; text boxes, drawing objects, pictures, and controls
are removed; pivot table data is converted to values.
See Also:
Workbook Conversion