OFF: Errors Working with a Binder That Contains a WorksheetLast reviewed: March 12, 1998Article ID: Q137674 |
The information in this article applies to:
SYMPTOMSIf a Binder contains a Microsoft Excel file that was created from a template, one or more of the following error messages may occur when you open the Binder or when you add or activate a section in of the Binder:
CAUSEThese problems occur because there are hidden Visual Basic for applications macros attached to these templates. These macros cannot be run within a Binder. Some templates that have been reported to cause these symptoms include the following:
Business Planner Car Lease Manager Change Request Expense Statement Invoice Loan Manager Personal Budgeter Purchase Order Sales Quote Timecard Village SoftwareNOTE: Not all of these templates are installed with a complete installation of Microsoft Office 97. Some of these templates are located in the \ValuPak folder on you Microsoft Office CD-ROM.
WORKAROUNDIf you have Binder that contains a section created from one of these templates, you can unbind it. To do this, use the right mouse button to click the Binder and then click Unbind on the shortcut menu. In some cases, error messages may continue to appear, and your only option is to click Retry. In other cases, Microsoft Binder may stop responding (hang). If Microsoft Binder hangs, press CTRL+ALT+DEL, and then select Microsoft Office Binders/Microsoft Excel and click End Task.
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONFor additional information on macros in Binders, please see the following articles in the Microsoft Knowledge Base:
ARTICLE-ID: Q134277 TITLE : OFF7: Illegal Operation When You Try to View Macro in Binder ARTICLE-ID: Q135249 TITLE : Cannot Write/Edit Visual Basic for Applications Code in Binder REFERENCESFor more information about creating Binders, choose the Office Binder Help Topics from the Help menu, Choose the Index tab and type in:
creating binders |
KBCategory: kbtool kberrmsg
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |