XL2000: Not All Database Sheets Are Listed in the Template Wizard (213978)

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 that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about creating a template by using the TemplateWizard, click Microsoft Excel Help on the Help menu, type what is the template wizard with data tracking? in the Office Assistant or the Answer Wizard, and then click Search to view the topic.