Understand Saving Excel Documents as Web Pages

One of the features of Excel is the ability to save the workbook, worksheet or chart in HTML format. This How To will give you an idea of what to keep in mind when you save an Excel document as a Web page:

• Some formatting and features of your worksheet are not retained when you save it as a Web page. Ex: 1904 Date System, Rotated or vertical text, Pattern fills, and Named cells or named ranges. On Macs, charts are saved as a graphics only. On Windows, charts are saved with some Excel functionality.
  
  
• After you save your worksheet as a Web page, use Dreamweaver to edit the Web page as it is now an .htm file.
  
  

• When saving a workbook as HTML, Excel may break the file down into separate component files. If only a single worksheet in the workbook contains data, Excel saves the workbook as a single file (Book1.htm, for example). However, if multiple worksheets in the workbook contain data, Excel uses frames to display the worksheets in a browser. Excel saves the frameset file with the path and file name you specify in the Save As dialog box.

  It saves the worksheets as separate HTML files in a folder with the same name as the frameset file, for example: