OFF95: Error Adding Excel Worksheet or Workbook to Binder

ID: Q133344

7.00 WINDOWS kbtool

The information in this article applies to:

SYMPTOMS

In Microsoft Office Binder, when you add a Microsoft Excel worksheet to a Binder, one of the following may occur:

CAUSE

This behavior occurs if Microsoft Excel is not running when you add the worksheet or workbook to the Binder and if a number of add-in files are loading when you start Microsoft Excel.

This behavior occurs because when you add a Microsoft Excel worksheet to a Binder, an invisible instance of Microsoft Excel is started. If Microsoft Excel takes too long to start; for example, if you have seven different add- ins loading, the OLE process involved in adding the file to the Binder times out, and you receive the error messages described above. This problem does not occur if Microsoft Excel is running, because the add-ins that are automatically loaded when you start Microsoft Excel are already loaded.

By default, when you perform a complete installation of Microsoft Excel, only four add-ins are loaded automatically, and this problem does not occur.

Note that if you attempt to add a Microsoft Excel worksheet to a Binder as a blank section after receiving either of the above error messages, you receive the following error message:

   The section could not be added to the Binder. The file already exists.

RESOLUTION

To work around this behavior, use either of the following methods.

Method 1: Reduce the number of add-ins that are loaded automatically in

          Microsoft Excel. To do this, use the following steps:

          a. Start Microsoft Excel.

          b. On the Tools menu, click Add-Ins.

          c. In the Add-Ins Available list, clear the check box next to any
             of the add-ins that you do not need to load automatically.

          d. Click OK.

Method 2: Start Microsoft Excel before you add a Microsoft Excel worksheet
          to a Binder.

KBCategory: kbtool KBSubcategory: offwin xlwin

Additional reference words: 7.00

Keywords          : offwin xlwin 
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 11, 1997