Unitech PA950 User Manual

Page 117

Advertising
background image

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

Advertising