Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template Wizard
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 -- Thank-you kindly |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template Wizard
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 " wrote: 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 -- Thank-you kindly |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template Wizard
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I distribute a template created with Template Wizard ? | Excel Discussion (Misc queries) | |||
Template Wizard... | Excel Discussion (Misc queries) | |||
Template Wizard | Excel Discussion (Misc queries) | |||
Template wizard - where is it? | New Users to Excel | |||
Template Wizard - Add-In | Excel Discussion (Misc queries) |