Unitech PA950 manual 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

10-117