Unsupported features in Excel Mobile
Excel workbooks created on your PC can be opened and edited on your device. However, Excel Mobile does not fully support some features, such as formulas and cell comments. Some data and formatting may be lost when you save the workbook on your device. Note the following regarding these Excel Mobile formatting considerations:
- Alignment. Horizontal, vertical, and wrap text attributes remain the same, but vertical text appears horizontal.
- Borders. Appear as a single line.
- Cell patterns. Patterns applied to cells are removed.
- Fonts and font sizes. Fonts not supported by your device are mapped to the closest font available. The original font is listed on your device. When the workbook is opened again in Excel on your PC, the data are displayed in the original font.
- Number formats. Numbers formatted using the Microsoft Excel 97 conditional formatting feature are displayed in Number format.
- Formulas and functions. Formulas containing references past row 16384 are replaced with #REF! Also, the following formulas are converted to values:
- formulas containing functions not supported by Excel Mobile
- formulas entered as an array or containing an array argument, for example, =SUM({1;2;3;4})
- formulas containing external link references or an intersection range reference
- Protection settings. If a password to open has been specified for a workbook, it cannot be opened in Excel Mobile. If a password to modify has been specified for a workbook, it can be opened in Excel Mobile but cannot be modified.
- Zoom settings. These are not retained. Excel supports a per worksheet zoom setting, while the Excel Mobile zoom setting is applied to the entire workbook.
- Worksheet names. In a cell in a worksheet, names that reference worksheets within the same workbook are displayed accurately. Names that refer to other workbooks, arrays such as ={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?" Tabs that are hidden in the workbook are not hidden in Excel Mobile.
- AutoFilter settings. These 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.
- Excel 2007 Binary (.xlsb) workbooks. Not supported.
- File conversions:
- .xls/.xlt files cannot be saved as .xlsx/.xltx files, and .xlsx/.xltx files cannot be saved as .xls/.xlt files
- rights-managed and password-protected files can be saved only in their original format
- Mandatory default file conversions upon saving:
- .xlsm/.xltm to .xlsx/.xltx
- .pxl/.pxt to .xls/.xlt
See also
Unsupported features in Word Mobile
Synchronizing documents, workbooks, and notes
How do I...
Automatically save files on a storage card
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
How do I...
Beam an item
Open a file
Automatically save files on a storage card
Delete an item
Synchronizing documents, workbooks, and notes
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web...
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web...
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web...
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web...
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web...
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web...
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web...
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.
Help on the Web...
Additional Help is available on the Web.
To browse the on-line Help:
- Open Internet Explorer Mobile.
- Tap Favorites.
- Tap Explore Windows Mobile.
To search Help on this device, tap here.