Cannot open Template Wizard

Cannot open Template Wizard

Didn't find your answer?

Hi All

I inherited a spreadsheet from someone with helpful stuff, macros etc but every time I open it I get a " Cannot Open Template Wizard" message which I click OK & carry on. Any idea how to get rid of this? Before you ask he's not sure how to get rid of it either, so you'd be helping us both.

Many thanks
Paul
Paul Scholes

Replies (4)

Please login or register to join the discussion.

Teignmouth
By Paul Scholes
20th Feb 2007 11:39

Richard AKA Wizard
What can I say? The moment you mentioned "names" I remembered seeing an odd one when I was defining my own, sure enough there was an "Auto_open21" name referring to a cell in a sub worksheet that had clearly become reduntant ages ago. Deleted this & Hey Presto.

Many thanks Richard
Paul

Thanks (0)
avatar
By RichardSchollar
20th Feb 2007 09:00

Template Wizard
Paul

As I understand it, the Template Wizard creates a connection to a database so that the Excel file can be used as a form to input data to the database tables. Now, if at some point this may have been the purpose of the file, then maybe the link (which may possibly have been to an excel file, not necessarily a Db program) exists somewhee in the sheet and is looking for the Template Wizard Add-In. This is pure conjecture on my part, I should point out - never having used the Wizard, I really don't know.

But, given that this may be possible, then one place to look will be in your Defined Names (accessible via Insert>Names>Define) and see if you have anything which you think is odd or unnecessary listed there. Delete any that you are sure are unnecessary and see if it makes a difference. Note that names can also be hidden, in which case you won't see them listed in the Names dialog. We can consider identifying any hidden names present if all else fails.

The other thing to check is within the Visual Basic Editor itself - open it up, click on your workbook in the top left Projects pane, and then go to the menus at the top and select Tools>References. In the dialog that opens, see if you have anything listed as MISSING or with a name that looks like Template Wizard (I have no idea what the actual name will be - they're not always seemingly logical - so it might be an idea to post back with a list of all the names that have a check against them). If for example MS Template Wizard is checked, simply unchecking it and saving down may well solve your problem.

Best regards

Richard

Thanks (0)
Teignmouth
By Paul Scholes
19th Feb 2007 18:57

thanks Richard
Have been through every macro on the sheet and can't find any line calling for this. Is there anywhere else you know to look in to see what Excel calls up?

Cheers
Paul

Thanks (0)
avatar
By RichardSchollar
15th Feb 2007 16:35

Template Wizard
I understand that the Template Wizard has not been supported by Excel possibly since xl2000 (not entirely sure about this as 2000 is the one version I've never used). It used to be an Add-In and would need to be installed via Tools>Add-Ins before it could be successfully used in a spreadsheet.

Is it possible that the code calls the template wizard? If so, and if it doesn't cause you any problems without it, you could comment out the code in the Visual Basic Editor and see if it:

1) Solves your problem
2) impairs the running of the macros in any way. (If not, then you know you can delete it)

Richard

Thanks (0)