Converting an Excel 2003 Report Template to Excel 2007

Converting an Excel 2003 template – (xlt), to a Excel 2007 template – (xltx)

I would like to convert my Alchemex Report templates from Excel 2003 to Excel 2007

Process:

1. Run your existing Excel 2003 report out as normal in Excel 2007
2. Minimise Excel 2007
3. Go back to Report Manager and unlink the xlt template from the report by selecting the Unlink Template  button on the Toolbar

 

 

 

 

 

 

4. Confirm that you would like to unlink the template
5. Notice that there is now no Template linked to your report
6. While your report is still selected, select the Create and Link  button on the Toolbar
7. Select the Workbook to link as Template (the Excel workbook you’ve minimized) and click OK

 

 

 

 

 

 

 

8. Confirm that you would like the Parameters on the Second Worksheet by clicking Yes
9. You will now be given the option to select the Template File Format

 

 

 

 

 

 

 

 

Select the Excel 2007 Template (*.xltx) and click OK

10. Click OK

The new template is now successfully linked to the report