Microsoft KB Archive/199896

= OFF2000: MS Excel Worksheet Does Not Show In Add Section Dialog Box =

Article ID: 199896

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Office Binder 2000

-



This article was previously published under Q199896





SYMPTOMS
If you try to add a Microsoft Excel Worksheet section to your binder, an item for Microsoft Excel Worksheet may not be displayed on the General tab of the Microsoft Office Binder Add Section dialog box.



CAUSE
You may not have an item for Microsoft Excel Worksheet section in the Binder Add Section dialog box if you have an Excel workbook template saved in the \Program Files\Microsoft Office\Templates folder.



WORKAROUND
If you do not see a Microsoft Excel Worksheet icon in the Add Section dialog box, but you want to insert a generic Microsoft Excel Worksheet section into your binder, follow these steps:
 * 1) On the Add menu, click Section.
 * 2) On the General tab of the Add Section dialog box, click Microsoft Excel Chart, and then click OK.

This will add a Microsoft Excel section that contains a chart sheet and a worksheet with some sample data for the chart.
 * 1) Right-click the chart sheet in this section, click Delete on the shortcut menu, and then click OK.

This will delete the chart sheet from your Microsoft Excel section.
 * 1) In the worksheet of your Microsoft Excel section, select the range A1:D7, point to Clear on the Edit menu, and then click All.

You will now have a Microsoft Excel section with a single worksheet in your binder.

NOTE: If you want to add more worksheets to your Microsoft Excel section, click Worksheet on the Insert menu.



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

