679470
153
Zoom out
Zoom in
Previous page
1/190
Next page
Using Other Applications | 153
Protection settings. Most worksheet and workbook protection
features are disabled but not removed. However, support
for password protection has been removed. Workbooks that
are password-protected or workbooks in which one or more
worksheets are password-protected cannot be opened. You must
remove the password protection in Excel on the PC and then
synchronize to open the file on the device.
Zoom settings. Are not retained. Excel supports a per worksheet
zoom setting, while the Excel Mobile 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 not hidden.
AutoFilter settings. Are removed. However, you can use the
AutoFilter command in Excel Mobile to perform similar functions.
If you have an AutoFilter applied to a worksheet that causes rows
to be hidden, the rows remain hidden when the file is opened in
Excel Mobile. Use the Unhide command to display the hidden
rows.
Chart formatting. All charts will be saved the way they are
shown 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.
Worksheet features. The following features are not supported
in Excel Mobile and are removed or modified when a workbook
is opened on the device: hidden sheets are not hidden; VBA
modules, macro sheets, and dialog sheets are removed and
replaced with a place holder sheet; text boxes, drawing objects,
pictures, lists, conditional formats, and controls are removed;
pivot table data is converted to values.
153


Need help? Post your question in this forum.

Forumrules


Report abuse

Libble takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Product:

For example, Anti-Semitic content, racist content, or material that could result in a violent physical act.

For example, a credit card number, a personal identification number, or an unlisted home address. Note that email addresses and full names are not considered private information.

Forumrules

To achieve meaningful questions, we apply the following rules:

Register

Register getting emails for O2 XDA Mini at:


You will receive an email to register for one or both of the options.


Get your user manual by e-mail

Enter your email address to receive the manual of O2 XDA Mini in the language / languages: English as an attachment in your email.

The manual is 5,82 mb in size.

 

You will receive the manual in your email within minutes. If you have not received an email, then probably have entered the wrong email address or your mailbox is too full. In addition, it may be that your ISP may have a maximum size for emails to receive.

The manual is sent by email. Check your email

If you have not received an email with the manual within fifteen minutes, it may be that you have a entered a wrong email address or that your ISP has set a maximum size to receive email that is smaller than the size of the manual.

The email address you have provided is not correct.

Please check the email address and correct it.

Your question is posted on this page

Would you like to receive an email when new answers and questions are posted? Please enter your email address.



Info