XL7: "There are no Open Workbooks" Running Template Wizard

ID: Q138620

7.00 WINDOWS kbtool kberrmsg

The information in this article applies to:

SYMPTOMS

When you run the Template Wizard from within Microsoft Excel for Windows 95, version 7.0, you may receive the following error message:

   There are no open workbooks.

CAUSE

This problem occurs if you click Template Wizard on the Data menu and your workbook only contains a Microsoft Excel version 4.0 macro sheet. The Template Wizard requires at least one worksheet in the active workbook.

RESOLUTION

To resolve this problem, insert a worksheet into the active workbook.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel for Windows 95, version 7.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

KBCategory: kbtool kberrmsg KBSubcategory:

Additional reference words: 7.00 error

Version           : 7.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996