OFF2000: MS Excel Worksheet Does Not Show In Add Section Dialog Box (199896)


The information in this article applies to:

  • Microsoft Excel 2000
  • 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.
  3. 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.
  4. 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.

REFERENCES

For more information about Adding Sections to a Binder, click Microsoft Office Binder Help on the Help menu, type Add a new document to a binder in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbnofix KB199896
©2003 Microsoft Corporation. All rights reserved.