OFF97: MS Excel Worksheet Does Not Show in Add Section Dialog

• Microsoft Office 97 for Windows
• Microsoft Office Binder 97
• Microsoft Excel 97 for Windows

SYMPTOMS

If you try to add a Microsoft Excel Worksheet section to your Binder, an item for Microsoft Excel Worksheet may not be displayed in the General tab of the Microsoft 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 a Microsoft 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 highlight 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.

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 the Index tab in Microsoft Binder Help, type the following text

sections, adding

Additional query words: OFF97 8.00

Keywords          : xlloadsave offbinder 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: June 3, 1999