"Do you want to save your changes?" message when you use SEND or SAVE AS in Excel Mobile for Windows Phone 7

Symptoms

When you use the SEND command or the SAVE AS command in Microsoft Excel Mobile for Windows Phone 7, you receive the following message:

Do you want to save your changes? Some formatting and content might be lost if you save this workbook.


Cause

This issue occurs because the workbook contains unsupported content. If you select YES, you may experience data loss. If you select NO, the edits are canceled.

Resolution

To resolve this issue, either select NO or use the Back key on your mobile device. Both actions cancel the save. Then, use Microsoft Excel 2010 for Windows to change the workbook.

More Information

The following table lists content types and the level of support in Excel Mobile 2010:

Content typeLevel of view supportRemarks
Cell contentCompletely supportedCell data beyond cell IV16384 is lost
Cell formatsCompletely supported
Number formatsCompletely supported
Merged cellsCompletely supported
HyperlinksPartially supportedClick on link does not work
Pivot tablesPartially supportedCannot change pivot filters
Pivot chartsPartially supported3D charts change to 2D charts
Freeze panesCompletely supported
Defined namesCompletely supported
FunctionCompletely supportedABS, ACOS, AND, ASIN, ATAN, ATAN2, AVERAGE, CHOOSE, COLUMNS, CONCATENATE, COS, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, DATEVALUE, DAVERAGE, DAY, DCOUNT, DCOUNTA, DDB, DEGREES, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP, ERROR.TYPE, EXACT, EXP, FACT, FIND, FV, HLOOKUP, HOUR, IF, INDEX, INT, IRR, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISTEXT, LEFT, LEN, LN, LOG, LOG10, LOOKUP, LOWER, MATCH, MAX, MID, MIN, MINUTE, MOD, MONTH, N, NA, NOT, NOW, NPER, NPV, OR, PI, PMT, POWER, PRODUCT, PROPER, PV, RADIANS, RAND, RANK, RATE, REPLACE, REPT, RIGHT, ROUND, ROWS, SECOND, SIN, SLN, SQRT, STDEV, STDEVP, SUBSTITUTE, SUM, SUMIF, SUMPRODUCT, SYD, T, TAN, TIME, TIMEVALUE, TODAY, TRIM, TRUNC, UPPER, VALUE, VAR, VARP, VLOOKUP, YEAR, FALSE, and TRUE.
TablesCompletely supportedIf Table header row is not changed; table is completely supported when round-tripped
ChartsPartially supported3D charts change to 2D charts
(see Chart table in this section for more information)
ThemesPartially supported
StylesPartially supported
Conditional formattingNot supported
PicturesNot supported
Clip artNot supported
ShapesNot supported
Smart ArtNot supported
SparkLinesNot supported
Text: FontsPartially supportedAll fonts on Phone
Text boxNot supported


Chart table
Chart typeMapped to
ColumnClustered Column
BarClustered Bar
AreaStacked Area
StockLine with Markers
Surface ChartsColumn
DoughnutLine with Markers
BubbleScatter with straight lines
RadarStacked Area Chart
LineLine
PiePie
ScatterScatter


Propriedades

ID do Artigo: 2461651 - Última Revisão: 8 de out de 2013 - Revisão: 1

Comentários