Microsoft KB Archive/234090

= SBFM2000: Reports Show Hidden Rows and Columns in Published Web Page =

Article ID: 234090

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Business Solutions Small Business Manager 7.5, when used with:
 * Microsoft Office 2000 Small Business Tools

-



This article was previously published under Q234090



SYMPTOMS
When you publish a report to the Web that was created in the Microsoft Small Business Financial Manager, rows and columns that were hidden are visible on the published Web page.



CAUSE
This problem occurs when you do the following:
 * You create a financial report using the Microsoft Small Business Financial Manager (SBFM).

-and-
 * You click either of the following commands on the File menu:
 * Save as Web Page
 * Web Page Preview



WORKAROUND
To publish a SBFM report as a Web page and maintain hidden rows and columns, follow these steps:
 * 1) Select the cells that you want to publish. For example, if you create a Balance Sheet report and your Total Liabilities and Owner's Equity is in cell H61, select cells F25 through H61.

One way to select these cells easily is by using the Go To feature. Press F5 to invoke the Go To dialog box. In the Reference box, type F25:H61 and click OK.
 * 1) On the File menu, click Save as Web Page.
 * 2) In the Save As dialog box, click Selection:$F$25:$H$61. If you want users to have interactivity with the workbook, click to select the Add interactivity check box and click Publish.
 * 3) Type a file name for your .htm file in the File name box.
 * 4) Click to select the Open published web page in browser check box, and click Publish.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: xl2000 off2000

Keywords: kbbug kbsbt kbpending KB234090

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.