How to set up Template Wizard in Excel 2007/2010?

[cavag4]

I have a template that was built with Excel 2003. This template calculates tonnes of product, and then dumps that data into an Excel 2003 database. This allows us to open a blank calculation template each time, while saving all the data in a different file. These sheets were connected using the Excel Template wizard. We now need to upgrade to Excel 2007 on one computer, and Excel 2010 on another computer. These newer versions of Excel do not have the Template Wizard feature. Can anyone tell me how to get the template to save the data to the Excel database worksheet in the newer versions of Excel?

 

[Papi]

If you still have the Template Wizard (TW) add-in file, copy it into the 2007 and 2010 Add-Ins folders. The TW does not take advantage of the new four digit file extensions in 2007 and 2010. Save your template as a 2003 .xlt template file and you can continue using the TW.