Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/169022

From BetaArchive Wiki

Article ID: 169022

Article Last Modified on 10/22/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q169022

SYMPTOMS

If you save your workbook as an HTML document, some of the cell formatting may not be saved with the workbook.

CAUSE

If you use the Conditional Formatting feature to apply formats to cells, the formatting is not saved with your workbook when you save it as an HTML document.

RESOLUTION

Currently, there is no way to save your workbook as an HTML document and have it preserve the formatting created by the Conditional Formatting feature.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

The Internet Assistant Wizard is not new to Microsoft Excel, but it has changed significantly since it was released as a free add-in available on the Microsoft World Wide Web site in January 1996. The Internet Assistant Wizard is now an installable component of Microsoft Office and/or Microsoft Excel, and has been enhanced to take advantage of the new Internet features of Microsoft Office, Microsoft FrontPage, and Microsoft Internet Explorer.

With the Internet Assistant Wizard, you can leverage existing Microsoft Excel spreadsheet data to create and distribute documents that can be viewed online with a Web browser, such as Microsoft Internet Explorer. By clicking a series of buttons in the wizard, you can convert spreadsheet data to HTML format, either as a separate Web document or into an existing Web document.

REFERENCES

For more information about Conditional Number formats, click the Index tab in Microsoft Excel 97 Help, type the following text

formatting cells, conditional formats


and then double-click the selected text to go to the "Apply conditional formats to cells" topic.

For more information about the Internet Assistant Wizard, click the Index tab in Microsoft Excel 97 Help, type the following text

internet


and then double-click the selected text to go to the "Add worksheet data or a chart to a Web page" topic.


Additional query words: XL97 html.xla

Keywords: kbbug KB169022