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

ID: Q199896


The information in this article applies to:
  • Microsoft Office 2000


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 this to be a problem in the Microsoft products 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.

Additional query words: OFF2000 xl2000

Keywords : kbdta xlloadsave offbinder
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: May 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.