Template Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know exatly how the template wizard works? I have been usung it
for a long time but I changed the databases a little, went through the wizard
again but it says the structure has changed and does not save the info. Need
help
 
Hi,

Question:
You must have I saved the file with .xlt extension, but why you can't use it
as a template?

Answer:
Excel does not save a file in template format if you type the .xlt file
extension in a file name. To save a file as a template, click Save As on the
File menu. In the Save as type box, click Template. In the Save in list,
locate and click the location where you want to save the template. In the
File name box, enter a file name, and then click Save.

Save custom templates in the Templates folder. If you save the file to a
different location, you can only open the file, not use it as a template.
Save the default workbook template (default workbook template: The Book.xlt
template that you create to change the default format of new workbooks. Excel
uses the template to create a blank workbook when you start Excel or create a
new workbook without specifying a template.) (Book.xlt) and the default sheet
template (default worksheet template: The Sheet.xlt template that you create
to change the default format of new worksheets. Excel uses the template to
create a blank worksheet when you add a new worksheet to a workbook.)
(Sheet.xlt) in the XLStart folder or the alternate startup folder (alternate
startup folder: A folder in addition to the XLStart folder that contains
workbooks or other files that you want to be opened automatically when you
start Excel and templates that you want to be available when you create new
workbooks.). The Templates folder is usually

C:\Documents and Settings\<user_name>\Application Data\Microsoft\Templates

and the XLStart folder is usually

C:\Program Files\Microsoft Office\Office11\XLStart

Challa Prabhu
 
The Wizard uses your input to make a new hidden worksheet within the book
that exports data to the database. (If you are familiar with VB, you can see
that the sheet is listed there as "very hidden." Unhide it, and you can see
exactly what the Wizard has set up.) This new sheet esentially stores all of
the values and references that you indicated you wanted exported when you
went through the Wizard menus. If the formatting of the headers in your
database aren't exactly the same as the ones in the hidden worksheet (and I
mean exact, down to capitalization), if the number of cells it thinks it
needs to export doesn't match the number that are listed across the hidden
sheet, if there is an extra column in the database, the Wizard gives you the
structure error. In my experience, it has saved the data anyway except for
the columns that don't match perfectly.

If you are brave enough to go in and mess with it, I would suggest opening
the file with Visual Basic and unhiding the TemplateInformation sheet. You
can then go through and check each column in the hidden worksheet to each in
the database for spelling, extra columns, etc. and make sure that the
"Number of columns" cell on the hidden sheet matches the number of columns
listed below.
Note that if you have added/subtracted values to be exported and modified
the database, older files based on a previous version of the template will
give you the structure error because they no longer match the altered
database.

Good luck!
 
Back
Top