When you save an Microsoft Excel worksheet in XML Spreadsheet format, many Excel features are retained, but some are not. Details are listed in the following table.
| Excel feature |
Result when saved as XML Spreadsheet |
| 1904 date system |
Retained |
| Asterisks that mark totals for OLAP data |
Retained |
| Auditing tracer arrows |
Not retained |
| Background refresh, retrieving data for each item in a page field individually |
Retained |
| Calculated fields |
Retained |
| Calculated items |
Retained |
| Cell comments |
Retained |
| Changes to Excel source data |
Retained |
| Character and cell formatting |
Retained |
| Chart and other graphic objects |
Not retained |
| Chart sheets, Macro sheets, Dialog sheets |
Not retained |
| Conditional formatting |
Retained |
| Custom calculations |
Retained |
| Custom sort order |
Retained |
| Custom views |
Not retained |
| Customized error values and empty cell values |
Retained |
| Data consolidation |
References are not retained. |
| Data validation restrictions and messages |
Retained |
| Distributed alignment |
Retained |
| Drawing object layers |
Not retained |
| External data ranges |
Retained |
| Grouped items in fields |
Retained |
| Indented formats |
Retained |
| Indented text |
Retained |
| Labels in formulas |
Retained |
| Lists |
List functionality is lost, but the data is retained. |
| Multiple fonts in a single cell |
Retained |
| Number formats |
Retained |
| Offline cube file |
Retained |
| Outlining |
Not retained |
| Page fields in rows or columns |
Retained |
| Password settings |
Data in password-protected worksheets and workbooks cannot be saved. To publish data that's protected, do not use a password. You can, however, save a database password with a worksheet query; users will be required to enter the password when the XML Spreadsheet is opened. |
| Pattern fills |
Retained |
| PivotTable Reports |
Retained |
| Precision as displayed |
Retained |
| Printing and page setup features |
Retained |
| R1C1 reference style |
Retained |
| References to data on other worksheets |
Retained |
| Rotated or vertical text |
Retained |
| Scenarios |
Not retained |
| Shared workbook information |
Not retained |
| Subtotals |
Numbers and calculations are retained. Group and outline features are not retained. |
| Subtotals displayed at the top of item groups |
Retained |
| Thai alignment |
Retained |
| Transition settings for Lotus compatibility |
Retained |
| User-defined function categories |
Not retained |
| Visual Basic for Applications projects |
Not retained |
| Web queries |
Retained |
