The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you use the Template Wizard to create a template, if the name of the workbook from which you create the template contains an apostrophe character ('), you receive the following error message in the Template Wizard where <workbook name> is the name of the workbook that contains an apostrophe, such as "it's an example.xls." CAUSE
This behavior occurs because the apostrophe character is reserved for use
in references in Microsoft Excel. When you use the Template Wizard to
create a template, if the workbook name that you use to create the template
contains an apostrophe, you receive the error message shown above in the
Template Wizard-Step 3 of 5 dialog box when you select a cell on the
worksheet and then press TAB or click the Field Name box.
RESOLUTIONTo avoid this behavior when you create a template using the Template Wizard, you should avoid using a workbook with a name that contains an apostrophe. You can rename your workbook to a name that does not contain an apostrophe by using Windows Explorer or My Computer, and then use the Template Wizard to create a template from this file. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATIONThe Template Wizard command is available on the Data menu when you load the Template Wizard With Data Tracking add-in. You can load this add-in by using the Add-Ins dialog box (Tools menu) to add the file WZTEMPLT.XLA from the Microsoft Excel LIBRARY folder. You can use this add-in to create a template that links selected cells in a workbook to fields in a database that you specify. When you base a new workbook on the template and enter data in the indicated cells, Microsoft Excel creates a new record in the database and copies the data to the corresponding data fields. REFERENCESFor more information about using the Template Wizard in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text Templatedouble-click the selected text, and then double-click When To Use The Template Wizard to go to the "When To Use The Template Wizard" topic. Additional query words:
Keywords : xlwin |
Last Reviewed: October 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |