XL: Not All Database Sheets Listed in Template Wizard

ID: Q132283

The information in this article applies to:

SYMPTOMS

In Microsoft Excel, when you use the Template Wizard to create and link a template to an existing database file, the Sheet list in the "Template Wizard - Step 4 of 5" dialog box may not contain all of the worksheets in the database file. Because of this, you cannot link cells in your template file to every sheet in the existing database file.

CAUSE

This behavior occurs because you can link data in a template file only to the first 25 worksheets in an existing database file. However, when you create a template by using the Template Wizard, and you link the template to a database file that contains more than 25 worksheets, you do not receive an error message that indicates that this limit exists. Also, you do not receive an error message that indicates that the extra worksheets in the database will fail to appear in the Sheet list.

WORKAROUND

To work around this behavior, make sure that the worksheets that you want to use in the database are the first 25 worksheets in the database file. If the database contains more than 25 worksheets, you must move the additional worksheets to a new database file in order to link these to a template file when you use the Template Wizard.

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 creating a template by using the Template Wizard, click the Index tab in Microsoft Excel Help, type the following text 

   Template
double-click the selected text, and then double-click "Create a template to export worksheet data to a database" to go to the "Create A Template To Export Worksheet Data To A Database" topic.

Additional query words: 7.00 8.00 97 

Keywords          : kbualink97 kbdta xlwiz xlwin 
Version           : WINDOWS:7.0,97
Platform          : WINDOWS

Last Reviewed: January 8, 1999