MS-Excel / General Formatting

What You Lose in HTML or HTM

When saving in HTML or HTM format, the following features will be lost in Excel 2007:

  • New Excel 2007 features
  • PivotTables and charts (they can be saved, but are lost when the file is opened in this format again in Excel)
  • VBA Projects

If you are using a pre-2007 version, the following features will be lost:

  • Unused number formats
  • Unused styles
  • Data consolidation settings
  • Scenarios
  • Natural language formulas (they are converted to standard range references)
  • Custom function categories
  • Strikethrough, subscript, and superscript elements
  • Change History
  • Customized page setup settings for charts that are embedded on a worksheet
  • List settings for ListBoxes and ComboBoxes from the Forms toolbar
  • Conditional formatting that is stored on an XLM macro sheet

Also, shared workbooks in versions of Excel before Excel 2007 will no longer be shared. The "Value (Y) axis crosses at category number" setting on the Scale tab of the Format Axis dialog box is not saved if the "Value (Y) axis crosses a maximum category" checkbox is checked. The "Vary colors by point" setting in the Format Data Series dialog box is not saved if the chart contains more than one data series.

[Previous] [Contents] [Next]

In this tutorial:

  1. Extract Data from a Corrupt Workbook
  2. If You Can Open Your Workbook
  3. What You Lose in HTML or HTM
  4. If You Cannot Open Your File